Focal Point
[Closed] Show DateTime fields without time

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

October 09, 2013, 05:15 AM
Peter
[Closed] Show DateTime fields without time
Hi,

We are using an Oracle database, meaning all of our date fields are considered datetime (HYYMDS)
--> For the most part, our time-portions are actually 00:00:00, so I would like to hide them as easy as possible.

The solution I had in mind was the following:
USAGE=HYYMD, ACTUAL=HYYMDS --> but this results in FOC1647

Is there any way to keep the time portion, but not show it in reports (not using a define)?

Note: the reason I don't want to end up with YYMD format is to avoid compatibility issues between YYMD fields and HYYMDS fields in my business view

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


Prod: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
Test: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
October 09, 2013, 09:48 AM
njsden
You can change their definition in the master as follows:

..., USAGE=YYMD, ACTUAL=DATE, $


That way they will be handled as "just dates" in the WebFOCUS layer.

If you have cases where the same field needs to be handled as Date-only under some circumstances and DateTime under others (hey, it's possible Smiler ), then you can define 2 different FIELDNAME's on the very same database one (ALIAS) as follows:

FIELDNAME=MY_DTTM, ALIAS=MY_DTTM, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=MY_DATE_ONLY, ALIAS=MY_DTTM, USAGE=YYMD, ACTUAL=DATE, $


That way, you can use "MY_DTTM" when DateTime calls for it, and "MY_DATE_ONLY" when only the Date piece is required. No DEFINES or date transformation expressions 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.
October 09, 2013, 04:30 PM
Waz
Spot on njsden,

Good One

One thing that you can do in a master file is have the same column multiple times, and for datetime stamps read them in, in different formats.


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!

October 10, 2013, 02:12 AM
Peter
I was hoping to be able to keep all my fields in the same format (DateTime) to prevent them being incompatible in InfoAssist. (comparing Date fields to DateTime fields requires formulas which I want to avoid for IA-users when possible)

But from what I understand it's not possible in such a way. (Strange as you can put a HYYMDS value in a HYYMD field within InfoAssist...)

Thanks for the help!


Prod: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
Test: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode