How to compare date type measure with functional keywords "today" or "now"
Hi experts,
I have a measure which is type "date". The measure is assigned in rule expression as "<meas_D> = now".
But when I tried to calculate a boolean type measure from comparison of them like "<meas_B> = if(<meas_D> == now, true, false)", no "true" is assigned to meas_D.
I guess the reason is "now" returns the date and time, which is different from date only.
1) I wonder beside defining another temp measure to take "now" first, then comparing it with meas_D, if there is another way.
2) can I do caculation on date type measure like add 7 days to 20170912 then it becomes 20170919?