Focal Point
DATEDIF with HGETC (current date) ?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6941002362

December 26, 2007, 01:33 PM
Stephen
DATEDIF 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


WebFocus 7.11/7.6
December 26, 2007, 05:13 PM
FrankDutch
For a DATEDIF you need to compare two DATE values.
Your second is an hour and date value.
First covert it to a DATE.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

December 26, 2007, 05:32 PM
Stephen
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');


WebFocus 7.11/7.6