I have a transaction file where the date is stored as YYMD, but the format is P9.

I need to select records with the WHERE statement and comparing it the the system variable that is the current date.

This message has been edited. Last edited by: Daren,

What kind of file is it?

If the ACTUAL is P9, can you make the FORMAT YYMD? If yes, that would solve your problem.

Also, system variable &YYMD is a numeric value that you can use in compares. Try it and see if it works.

The&YYMD worked perfectly with my P9 format date.

Thanks Ginny!