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,

The length is A11, what is stored in the RUNDATE field ?

Is it MMDDYYYY or does it have other formatting ?

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.

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.

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.