Format date yyyy-MM-dd

poppins · 2015-06-22

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 · 2015-06-22

Try this:

FORMAT(date,0,9);

poppins · 2015-06-22

Luc Van Dyck wrote:
Try this:
FORMAT(date,0,9);

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

Luc_VanDyck · 2015-06-22

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

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

returns

2015-06-22

.

poppins · 2015-06-22

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 · 2015-06-23

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 · 2015-06-23

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.

Howdy, Stranger!

Quick Links

Categories

Format date yyyy-MM-dd

Comments