I am trying to compare a date field (DATE_ACTIVATION_FINAL) in HYYMDS to the current date.
DATE2/HYYMDS = HGETC(10, 'HYYMDS');
DAYS/I8 = DATEDIF(DATE_ACTIVATION_FINAL,DATE2,'D');
I get the following error...
(FOC36355) INVALID TYPE OF ARGUMENT #2 FOR USER FUNCTION DATEDIF
Am I pulling the the current date incorrectly, or is the problem in the DATEDIF ?
For a DATEDIF you need to compare two DATE values.
Your second is an hour and date value.
First covert it to a DATE.
Thanks Frank. Both fields use the HYYMDS format. I added lines 3 and 4 below and that seems to have done the trick...
DATE1/HYYMDS = DATE_ACTIVATION_FINAL;
DATE2/HYYMDS = HGETC(10, 'HYYMD');
DATE3/YYMD = HDATE(DATE1, 'YYMD');
DATE4/YYMD = HDATE(DATE2, 'YYMD');
DAYS/I8 = DATEDIF(DATE3,DATE4,'D');
|Powered by Social Strata|