I would like to create a define field using the TODAY function only in YYDD format: For example I would like to see the following value for this define field: 20130402

I've tried TODAY() but, I don't know which argument to use?

This message has been edited. Last edited by: <Kathryn Henning>,

You can use system & variable DATEYYMD for this.


DEFINE FILE CAR
DT/YYMD= '&DATEYYMD';
END

thanks
Sashanka

Thanks for your assistance. After looking at your suggestion, I have created the following define field:

DEFINE FILE AP_CHECK
DT/YYMD=&DATEYYMD;
END

The value I'm getting is 1901/09/08. How do I get today's date without the slashes? eg. 20130402

XDATE/A8 = '&YYMD.EVAL';

SOLVED

That worked, thanks Tom.