-SET &CurrentDate = &DATE;
-? &CurrentDate

Yields:

CURRENTLY DEFINED & VARIABLES STARTING WITH 'CurrentDate':
&CurrentDate = 11/27/13

I would like it to be

CURRENTLY DEFINED & VARIABLES STARTING WITH 'CurrentDate':
&CurrentDate = 2013-11-27

The DATEfmt below is invalid.
-SET &CurrentDate = &DATEYY-M-D;

I can do it with a long EDIT and concatenation but I assumed their was some easy way?

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

-SET &CurrentDate = DATETRAN(&YYMD, '(YYMD)', '(-)','EN', 50, 'A50');
-? &YYMD
-? &CurrentDate

Yeilds:

CURRENTLY DEFINED & VARIABLES STARTING WITH 'YYMD':
&YYMD = 20131127
CURRENTLY DEFINED & VARIABLES STARTING WITH 'CurrentDate':
&CurrentDate = i018-02-25

I obviously do not understand this sorry.

There is that book "1001 Ways to work with Dates", but alas i don't have one.
i think DATETRAN might be one of those functions that is tough to make work on &vars, not sure.
so, as you say, alot of use of EDIT,
or... cheat.
gets the job done, not quite as elegantly as you might like..
DEFINE FILE ibisamp/CAR
RUN_DATE/YYMD WITH COUNTRY =&YYMD.EVAL ;
DATE2/A10=DATETRAN(RUN_DATE, '(YYMD)', '(-)', 'EN', 10, DATE2)
END
TABLE FILE ibisamp/CAR
PRINT DATE2
IF RECORDLIMIT IS 1
ON TABLE SAVE
END
-RUN
-READ SAVE &newdate.A10
-TYPE &newdate

Tres simple!
-* File test2.fex
-SET &CURRENTDATE1 = &YYMD;
-? &CURRENTDATE1
-SET &CURRENTDATE2 = EDIT('&CURRENTDATE1.EVAL','9999-99-99');
-? &CURRENTDATE2
-EXIT
Happy Thanksgiving

Plus simple! but it's all the same really

-SET &CurrentDate=EDIT(&YYMD,'9999-99-99');
-TYPE &CurrentDate

Thanks all. I did give up on the DATETRAN and just went back to the EDIT.

-SET &CurrentDashedDate = EDIT(&YYMD, '9999-99-99');

Thanks for the help.

Steven,
Would have worked fine if you add quotes around the 1st &YYMD; the EDIT is easier:

-SET &CurrentDate = DATETRAN('&YYMD', '(YYMD)', '(-)','EN', 50, 'A50');
-? &YYMD
-? &CurrentDate[/quote]