I have two check box namely HOld and Freeze,
if both are selected and saved A new record should be saved as 2017Q1(example)
Thanks IN advance.!!
2 risposte
Try This , TEXT(YEAR(TODAY())) &
IF( MONTH(TODAY())>= 1 && MONTH(TODAY())<= 3, "Q1",
IF( MONTH(TODAY())>= 4 && MONTH(TODAY())<= 6, "Q2",
IF( MONTH(TODAY())>= 7 && MONTH(TODAY())<= 9, "Q3",
IF( MONTH(TODAY())>= 10 && MONTH(TODAY())< 12, "Q4",
" ")
)
)
)
