I need code to convert a date field from HYYMDm to YYMD format in a focus table. I can't seem to find an example, any help would be greatly appreciated.
Thanks JVThis message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8105m Windows, All Outputs
August 24, 2020, 12:36 PM
FP Mod Chuck
JV
You should just need to change the master file to USAGE=YYMD, ACTUAL=DATE
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 24, 2020, 12:47 PM
Jveselka
I figured it by changing it in the sql code I am reading in.
CONVERT(DATE, CLM.CLM_LOSS_DT, 112) AS 'ACC_DT',
WebFOCUS 8105m Windows, All Outputs
August 26, 2020, 03:16 PM
jgelona
HDATE function in WebFOCUS
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.