Format of TimeStamp Date Changes After Exporting (mm/dd/yyyy to m/d/yyy)

[crionsynx]

Is there a way to retain the original format of timestamp date when exported? In the table the format is mm/dd/yyyy but when data is exported it changes to m/d/yyyy.

This is the format in the table.

 

While this is the format in the exported file.

I need to have the same format(mm/dd/yyyy) for my exported file.

 

[Hastur]

Hello @crionsynx

You may use additional formula field to get needed layout.

Here is the example:

CONVERT(nvarchar, [@field:asdwasd], 101) + ' ' +  CONVERT(nvarchar, [@field:asdwasd], 108)

 

[crionsynx]

Hi @Hastur

 

It worked!

Since it is already considered as string (nvarchar), format is retained after export.

I appreciate your help.