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
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,
Change the date to Alpha something like this
DATE2/A10=DATETRAN(RUN_DATE, '(MDYY)', '(-)', 'EN', 10, DATE2)
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.
Try searching on HCNVRT.
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.
HCNVRT works fine.thanks all.
|Powered by Social Strata|