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] Convert Date/Time to Date only
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Convert Date/Time to Date only
 Login/Join
 
Member
posted
I have a field called HDCHGDT that is in HYYMDm format. I want to convert it to YYMD format. I'd like it to be a new define field called CHGDT. What would the formula need to be in the Define Field section?

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


WebFOCUS 7.6.4
Windows XP
.txt, Excel, etc.
 
Posts: 6 | Registered: February 18, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Have you tried looking at the documentation?

Using Functions > Date and Time Functions > HDATE: Converting the Date Portion of a Date-Time Value to a Date Format


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Have you tried looking at the documentation?


No. I tend to avoid eye contact with documentation. As a child, my mother was killed by a documentation street gang and I have never recovered. Thanks for bringing up this painful memory.

Also, thanks for pointing out the correct function.


WebFOCUS 7.6.4
Windows XP
.txt, Excel, etc.
 
Posts: 6 | Registered: February 18, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Well, I'll be throwing that book at you every chance I get.

Good luck.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
Really now benji ,

Gotta RTFM, Read The FOCUS Manuals, or whatever other manuals you'd like to throw in there...

Doug


   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Most recent: 8204 Gen 48 in Test and Production.
   Currently Available. Please contact me.
 
Posts: 2976 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Expert
posted Hide Post


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Gotta RTFM

Thank you for your not-at-all belated post. Very useful! One day I aspire to be as friendly and welcoming to new users as you.


WebFOCUS 7.6.4
Windows XP
.txt, Excel, etc.
 
Posts: 6 | Registered: February 18, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Benji, welcome aboard. A suggestion for you. Check into the (well worth) $25 purchase of the "(Almost)1001 Ways to Work With DATES in WebFOCUS." book. Many of us have found it well worth the investment. Good Luck. Ira.


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | 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] Convert Date/Time to Date only

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