[SOLVED] DATEDIF between SQL DATETIME AND CURRENT DATE

Focal Point

This topic can be found at:
https://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.07 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