CUIC Scheduled Report Date Time Format in .CSV

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:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~