AnsweredAssumed Answered

Find using current date

Question asked by DavidGunter on Apr 13, 2016
Latest reply on Apr 13, 2016 by DavidGunter

My script to locate records finding by balance owing >0 and within 60 days of arrival date looks like this;

 

Go to layout: Reservation

Perform Find[Specified Find requests; Find records; Criteria: Reservation:: balance owing ">"

Constrain FoundSet [Specified Find requests; Find records; Criteria: Reservation:: arrives < //+60

 

The second statement is problematic. I tried using get < (currentdate) +60   but that fails also.

 

I can't use a global field for arrives as that would change all the dates.  Any suggestions would be greatly appreciated.

Outcomes