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]Can time be retrieved despite USAGE=YYMD?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Can time be retrieved despite USAGE=YYMD?
 Login/Join
 
Member
posted
I am working with a date field that is described as USAGE=YYMD and ACTUAL=DATE and which holds both date and time components. In my report, I need to compare its values to those of a datetime field that is HYYMDI. I cannot change the master files.

What I do not understand from the documentation is whether the above USAGE strips the time components from the field before values are returned, or whether USAGE is only a formatting instruction for the report output while the time components are still accessible. For the comparison I am converting the field to HYYMDI using the HDTTM function, but predictably I get midnight as the time. Is there a way to get the correct time back?

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 7.7.03
Windows 7 64-bit
 
Posts: 17 | Registered: February 23, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Hi DomR,

It is the "ACTUAL=DATE" setting that is instructing the adapter to retrieve only the "date" portion from your DB column. USAGE=YYMD just is formatting to be used as '2016/04/19' for display purposes.

For you to access the "time" portion of your DB field, you'll need to have ACTUAL=HYYMDI with a compatible USAGE (such as HYYMDI). Only then you can perform any time operations you'll need.

That change has to be done at the metadata layer so if you can't change the master then you won't be able to go much further.

If the reason for not changing the master is that this field is already used in other reports and needs to be treated as a date only (no time portion), you could potentially add another field to the masterfile using the same ALIAS (so it refers to the very same DB column) along the appropriate combination of ACTUAL and USAGE as needed.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Hi njsden,

Thanks for your answer, this clears things up for me. I will ask our administrator to add another field to the master file that retains both the date and time portions, as you suggested.


WebFOCUS 7.7.03
Windows 7 64-bit
 
Posts: 17 | Registered: February 23, 2016Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Can time be retrieved despite USAGE=YYMD?

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