Hi,
If I export a report to excel manually (Export > runs to file, web page – save CSV )
Date Format is 16/06/2015 00:00:00 ( DD/MM/YYYY HH:MM:SS )
If I schedule it to save it to remote location as csv file the date format is different
00:00.0 ( MM:SS.0 ).
Is there a way to change the date format to display it as ( DD/MM/YYYY HH:MM:SS ) instead of changing it manually.
Please help.
Many Thanks,
KAvya
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Date Time format in a scheduled report of type CSV is :
Day_of_week Month Date_of_Month HH:MM:SS SERVER_TIMEZONE YYYY.
For Example, Fri Oct 24 01:00:00 EDT 2014.
This format is constant and it is as per design.
Refer the note in below user documentation:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Comments
0 comments
Please sign in to leave a comment.