Skip to Content
0
Former Member
Aug 01, 2014 at 09:43 AM

Date Expression in Datawindow

27 Views

Dear,

I have a problem making script inside datawindow using expression for date and text color

s01_prod_date > SubString(Replace(Convert(varchar(10), getdate()-2, 112), '-', ''),1,8);

the logic is when date is not yet 2 days than (s01_prod_date), data windows text color is Red and after that normal text color

please help,

anyone who usually handle about datawindow expression

Thanks Before