When invoking the %DATEVAL macro, what is the correct syntax for the parameters passed?

Document ID : KB000045832
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

When invoking the %DATEVAL macro, what is the correct syntax for the parameters passed?

Environment:  

CA Easytrieve Release 11.6

Answer: 

Page 444 of the CA Easytrieve Programming Guide shows: 

     DATEVAL [field] [format] [THRESHOLD] 

On page 445, it shows these are some of the more comment formats: 

     MMDDYY MMDDCCYY YYMMDD YYDDD (Julian) 

Additional Information:

If the century is not part of the date format specified above, you will need to also specify THRESHOLD with a value.

Please see page 446 for more information on THRESHOLD parm.