Date expression in conditional format
Posted: Thu Aug 15, 2019 1:04 am
What would be the expression in a conditional format expression to say display the STATUS field in red text if the STARTDATE field is up to two days before today or today or any day after today?
I thought it would be something like: source.STARTDATE > dateadd(dd,-3,datediff(dd,0,getdate())) . But this throws errors that dateadd, dd, and getdate are not declared and the report does not run.
Thank you!
I thought it would be something like: source.STARTDATE > dateadd(dd,-3,datediff(dd,0,getdate())) . But this throws errors that dateadd, dd, and getdate are not declared and the report does not run.
Thank you!