Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Dates in CSV format.
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Dates in CSV format.
 Login/Join
 
Platinum Member
posted
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.
 
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.
 
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try searching on HCNVRT.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
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.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6216 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
HCNVRT works fine.thanks all.


7.6.7
windows
PDF,EXCEL.
 
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Dates in CSV format.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.