Date expression in conditional format

Stimulsoft Reports.Flex discussion
Locked
ssteketee
Posts: 10
Joined: Mon Jan 14, 2019 1:01 am

Date expression in conditional format

Post by ssteketee »

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!
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Date expression in conditional format

Post by Lech Kulikowski »

Hello,

You can use AddDays():
source.STARTDATE > Today.AddDays(-3)

Thank you.
Locked