Focal Point
[SOLVED] DATEDIF between SQL DATETIME AND CURRENT DATE

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

June 18, 2019, 04:12 PM
DipJen
[SOLVED] DATEDIF between SQL DATETIME AND CURRENT DATE
Hi,
How to do DATEDIF between Datetime field and current date.

tried couple of ways but its not working...
HDIFF( REQOPENDATETIME , &YYMD , 'DAY', 'D12.2')

Trying to add this as define field on report.

Thanks
DP

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
June 19, 2019, 03:01 AM
Tony A
If you check the document for function calls you would know that they have specific input requirements.

Check them out here

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
June 19, 2019, 09:11 AM
BabakNYC
  
DTDIFF(DT_CURRENT_DATE(), REQOPENDATETIME , DAY )



WebFOCUS 8206, Unix, Windows