Skip to Content
0
Former Member
May 20, 2016 at 04:16 AM

Date format in CSV file

803 Views

Hi Experts,

I need your help in one of my issue,

I wanted to display CREATE DATE(Current date) in header part of report after exporting it into CSV format

and Date format should be "YYYY-MM-DD".

For this I created a variable at Universe Level which is like

CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD]


But after exporting this file into CSV format the date format gets changed and it displays the date like "DD/MM/YYYY"

I also tried REPLACE(CONVERT(VARCHAR(10), GETDATE(), 111), '/', '-') AS [YYYY-MM-DD]


But the result is same like "DD/MM/YYYY"

Version SAP 4.1 SP 1

If you need any other information do ask.

Thanks in Advance,

Priyanka