Forum Discussion
date format doesn't work in if function
Hi, I've tried the following if statement in a calculated measure: TestDate = if(1=1,now(),0) But instead of a date I am getting this output when I put the measure into a Card: 42K I've...
Because the value-if-false is not a date. If you replace that with a date value, then you'll be fine.
Example: TestDate = if(1=1,now(),DATE(2017,1,1))
Because the value-if-false is not a date. If you replace that with a date value, then you'll be fine.
Example: TestDate = if(1=1,now(),DATE(2017,1,1))
Thank you Marcel :-)