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] Date conversion
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Date conversion
 Login/Join
 
Gold member
posted
I have a date field called RUNDATE in format MDY (I use &Date to populate it) and the field length is A11. I am trying to convert it to DMY field using the following compute
COMPUTE CONV_FIELD/DMY = DATECVT(RUNDATE, 'A8MDY', 'DMY');
I am getting the error (FOC36355 - Invalid type of argument #1 for user function DATECVT).
I have also tried converting it to date time format using
DT2/HYYMDIA = HDTTM(RUNDATE, 8, 'HYYMDIA');
but get the same error. Eventually, I need to extract the week, month, year from the date but before that I need to convert the date in alphanumeric format to date-time format and can't seem to do that. Any input is appreciated. Thanks.

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


WebFOCUS 7.6.10
Windows
all output (Excel, HTML, PDF)
 
Posts: 69 | Registered: March 11, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
The length is A11, what is stored in the RUNDATE field ?

Is it MMDDYYYY or does it have other formatting ?


Waz...

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

 
Posts: 6131 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I am not sure about the format type A11 which you have mentioned in the post.

I will tell you what i know.

1) Assume the Date format is A8.
2) In DEFINE
DEFINE TABLE TABLENAME
Var1/A8YYMD=Date; (Date is of format A8)
Var2/YYMD=Var1;
Var3/DMY=DATECVT(Var2,'YYMD','DMY');

I tried the above code it worked. I wish this helps you.


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
If you look in the manual for the two functions you mentioned, you'll see that the input field has to be a date field in both cases. And A11 is not a date field. That means that you'll have to convert your A11 field to a date field first. And that's where the format question Waz asked comes into play.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks guys.
GamP, the date was getting stored in an alpha field. I changed that to a date field and now everything works. Thanks for pointing this out.


WebFOCUS 7.6.10
Windows
all output (Excel, HTML, PDF)
 
Posts: 69 | Registered: March 11, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Date conversion

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