CUIC Scheduled Report Date Time Format in .CSV

[RJ5]

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

[vesane]

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:

• Configure a Report To Save to Remote Location