Hello,
i know for you guys this is quiet easy. But it,s friday and i have a plank in front of my head. (German proverb) I want to convert the
Date 01/01/2011 in 01.01.2011 Format DMYY.

greetings and nice weekend

Christian

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

How about this ?

DEFINE FILE CAR
  D1/DMYY WITH COUNTRY = 01012011;
  D2/D.M.YY = D1;
  D3/D-M-YY = D1;
END

TABLE FILE CAR
BY COUNTRY
BY D1
BY D2
BY D3
END

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

D2/D.M.YY = D1;

Very interesting!

I solved it my self!!!

DATE1_DMYY/A8DMYY=HDATE(TABLE.TABLE.DATE, 'DMYY');
DATE2_DMYY/A10=EDIT(DATE1_DMYY,'99')|'.'|EDIT(DATE1_DMYY,'$$99')|'.'|EDIT(DATE1_DMYY,'$$$$9999');

WOW, works for any date format!

quote:

D4/M-D-YY = D1;
D5/M-YY = D1;
D6/M=D1;

Francis, does this documented anywhere?

I've never seen this anywhere!

It is documented, see here and search for
Controlling the Date Separator

... but it's a kind of "hidden"

-Fred-

Thanks for the Doc link.

I really like "Y|M|D" to eliminate the separation character!