Rounding Calculations with dates

Zenobia

Registered User.
Local time
Today, 19:28
Joined
Jan 28, 2011
Messages
35
LengthDaysOverDue: Now()-[DueDate]

Hello I'm trying to round this up to full numbers in my query however i cannot get it work,

Can any one shed any light on how to round this calculation to whole numbers?

Thank you
 
Hopefully you found the DateDiff function.
Or perhaps you found to use Date() instead of Now().
 

Users who are viewing this thread

Back
Top Bottom