June 18, 2019, 04:12 PMDipJen
[SOLVED] DATEDIF between SQL DATETIME AND CURRENT DATE
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.
DPThis message has been edited. Last edited by: FP Mod Chuck,
June 19, 2019, 03:01 AMTony A
If you check the document for function calls you would know that they have specific input requirements.
Check them out here
June 19, 2019, 09:11 AMBabakNYC
DTDIFF(DT_CURRENT_DATE(), REQOPENDATETIME , DAY )