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] Change HYYMDm to YYMD
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Change HYYMDm to YYMD
 Login/Join
 
Platinum Member
posted
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
 
Posts: 154 | Registered: August 23, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 2064 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 154 | Registered: August 23, 2010Reply With QuoteReport This Post
Master
posted Hide Post
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.
 
Posts: 970 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Change HYYMDm to YYMD

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