 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Date conversion | Login/Join |
| Gold member |
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) | ||
|
| Expert |
The length is A11, what is stored in the RUNDATE field ? Is it MMDDYYYY or does it have other formatting ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
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 | |||
|
| Virtuoso |
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
| |||||||||
| ||||||||||
| Gold member |
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) | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic | View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |