Focal Point
[SOLVED] Dates in CSV format.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/472106515

August 25, 2010, 08:46 AM
swati
[SOLVED] Dates in CSV format.
Hi all,i have two fields i.e; start date time & end date time.when i print these dates with CSV as output i am getting the output as 2.01007E+16
& 2.01005E+16


but if i use excel or Html format as output i am getting the start date time & end date time as 2010/07/22 17:06:23 & 2010/05/05 14:58:59.

How to get the CSV Output dates also as of the excel/Html format as mentioned above.

please suggest...

This message has been edited. Last edited by: Kerry,


7.6.7
windows
PDF,EXCEL.
August 25, 2010, 09:12 AM
Prarie
Change the date to Alpha something like this
RUN_DATE/MDYY=&MDYY;
DATE2/A10=DATETRAN(RUN_DATE, '(MDYY)', '(-)', 'EN', 10, DATE2)


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
August 25, 2010, 10:45 AM
swati
Hi prarie,

the DATETRAN function works for the date fields only,But i have the start date time & end date time fields.so start date time field has date and also time together ,similarly for the end date time.the format is 2010/07/22 17:06:23 .


please advise How can i get this work.


7.6.7
windows
PDF,EXCEL.
August 25, 2010, 11:19 AM
Prarie
Try searching on HCNVRT.
August 25, 2010, 05:41 PM
Waz
You will find that the date time fields are OK in the CSV file, check with a text editor.

as the date time is a large number, excel will always show it in scientific format.

The question is what will be using this CSV file ?

Is it Excel, then your should format the date time as Prarie suggests.

If its for some other program, then you may not have to, in fact formatting it as a string may cause problems.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

August 26, 2010, 11:15 AM
swati
HCNVRT works fine.thanks all.


7.6.7
windows
PDF,EXCEL.