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     Date time conversion
Go
New
Search
Notify
Tools
Reply
  
Date time conversion
 Login/Join
 
Platinum Member
posted
I have a date format '2007-01-17 00:00' that I am trying to convert for a report. Does anyone know of a function that would work or the format I could use with the edit function. I've tryed HPART and HCNVRT with no luck...

Any suggestions




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
What is the data format of the field, alpha or DATE or HYYMDS? There are no seconds or milliseconds?

What are you trying to convert it to?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I've not worked with that format, but in the master if it is a usage USAGE=HYYMDS, would HDATE work?


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
If you never use the time part of that date field you can also change the master.
USAGE=YYMD, Actual=DATE.
Or add an extra field in the master witch points to the same field and with the settings mentioned above.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Date time conversion

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