Have a request to create a "report" that if a ship date is after today to pull show the record on the "Report", what is the smartest way to create that script?
Thanks for the help, appreciate this great community!
Go to Layout [ any layout based on the table you want to search, if you aren't already on one ]
Set Error Capture [ on ]
Enter find mode
Set field [ Table::shipDate ; ">" & Get ( CurrentDate )
If [ Get ( LastError ) <> 0 ]
//handle logic for no ship dates in the future
//go to report layout
Enter Find Mode
Set Field [ table::date ; ">" & GetAsDate(Get(CurrentHostTimestamp)) ]
Retrieving data ...