Format date yyyy-MM-dd

poppins

Hi everyone,

I need to format a date into yyyy-MM-dd, for example 2015-06-22.
I tried the following:

FORMAT(date,0,'<Year4><Month,2><Day,2>')

But I got 20150622 as a result.

I tried the following:

FORMAT(date,0,'<Year4>-<Month,2>-<Day,2>')

but I got 22/06/2015 as a result.

What shall I do?
Thanks in advance

Luc_VanDyck

Try this:

FORMAT(date,0,9);

poppins

Luc Van Dyck wrote:

Try this:

FORMAT(date,0,9);

Just tried it but got 22/06/2015 as a result

Luc_VanDyck

What version of NAV are you using? In NAV 2015, the code

MESSAGE(FORMAT(TODAY,0,9));

returns

2015-06-22

.

poppins

Luc Van Dyck wrote:

What version of NAV are you using? In NAV 2015, the code

MESSAGE(FORMAT(TODAY,0,9));

returns

2015-06-22

.

I am using NAV 2013.
You're right, the message returns 2015-06-22 but when I write it to my .csv file, I get 22/06/2015

JonasA

I just tried this and I got '2015-06-23' using the following code (Using Dynamics NAV 2015 CU3):

Variables:
File = File
OutStream = OutStream

File.CREATE('c:\temp\data.csv');
File.CREATEOUTSTREAM(OutStream);
OutStream.WRITETEXT(FORMAT(TODAY, 0, 9));
File.CLOSE;

raa

poppins wrote:

Luc Van Dyck wrote:

What version of NAV are you using? In NAV 2015, the code

MESSAGE(FORMAT(TODAY,0,9));

returns

2015-06-22

.

I am using NAV 2013.
You're right, the message returns 2015-06-22 but when I write it to my .csv file, I get 22/06/2015

Is the date formatted in the same way if you open your .csv file in a text editor instead of Excel, for example Notepad.
Excel usually convert fields to local format if it is able to guess the data type.