Date format yymmdd

Business Central/NAV Developers Forum
1

Dear,

I require the following date format, it should be as follows :‘YYMMDD’.

I did use the function DATE2DMY but i got the format '2010/1/25 instead of 10/01/25.

Can anybody please help me??

Thanks in adv.

2

Hi Liizz,

try to use format instead for the date format you like FORMAT(gdate,’// <Day,2>’)

you can also search here before posting your problem. :slight_smile:

Chad

3

FORMAT(gdate, 0, ‘// <Day,2>’) [;)]