Filtering on the RCL field in TeleMagic for Windows

You cannot filter on the RCL field using the .TODAY function. You can duplicate the .TODAY function using the expression builder, however:

SUBSTR(contact1.rcl,1,10)=DTOS(DATE())

This expression will find the records with today's date in the recall field. To find a range of dates, use one of the following expressions:

SUBSTR(contact1.rcl,1,10)>=DTOS(DATE()-90)

This expression will find records with a recall scheduled 90 days ago or later.

SUBSTR(contact1.rcl,1,10)>=DTOS(DATE()) AND SUBSTR(contact1.rcl,1,10)
This expression will find records with a recall scheduled in the next 7 days.

 

-- End of FAQ #503

FAQ ID #503

Product Related: TeleMagic 3.5x

Last Updated: March 20, 2000