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,