Hi all, I have a variable in a crystal report that I’m trying to recreate in webi. It’s to show sales between 8 and 14 days ago. The webi variable below isn’t working, does anyone know the correct syntax to use please?
crystal variable
if {orddeth1.o-date} in currentdate - 8 to currentdate - 14 then {orddeth1.o-sentqty}
webi variable
=If([Delivery Date]<=CurrentDate()) And
([Delivery Date]>=RelativeDate(CurrentDate();-14;DayPeriod)) And
([Delivery Date]>=RelativeDate(CurrentDate();+8;DayPeriod))
Then “Y” Else “N”