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!
Date expression in conditional format
-
- Posts: 6417
- Joined: Tue Mar 20, 2018 5:34 am
Re: Date expression in conditional format
Hello,
You can use AddDays():
source.STARTDATE > Today.AddDays(-3)
Thank you.
You can use AddDays():
source.STARTDATE > Today.AddDays(-3)
Thank you.