Focal Point
[SOLVED] Change HYYMDm to YYMD

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

August 24, 2020, 10:57 AM
Jveselka
[SOLVED] Change HYYMDm to YYMD
WF 8150m

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
JV

This 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.