Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     DATEDIF with HGETC (current date) ?
Go
New
Search
Notify
Tools
Reply
  
DATEDIF with HGETC (current date) ?
 Login/Join
 
Silver Member
posted
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
 
Posts: 38 | Registered: May 20, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
 
Posts: 38 | Registered: May 20, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     DATEDIF with HGETC (current date) ?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.