December 26, 2007, 01:33 PM
StephenDATEDIF with HGETC (current date) ?
I am trying to compare a date field (DATE_ACTIVATION_FINAL) in HYYMDS to the current date.
DEFINE...
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 ?
Thanks
Stephen
December 26, 2007, 05:13 PM
FrankDutchFor a DATEDIF you need to compare two DATE values.
Your second is an hour and date value.
First covert it to a DATE.
December 26, 2007, 05:32 PM
StephenThanks 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');