datediff issue

[amien]

i have two dates:

20090421 and 20090501 .. i need the datediff in days.

Date(LastPaymentDate,'YYYYMMDD') - Date(InvoiceDueDate,'YYYYMMDD') gives me 80

[amien · Accepted solution]

nevermind

date#(LastPaymentDate,'YYYYMMDD') - date#(InvoiceDueDate,'YYYYMMDD') as Due

[#3]

Hi

Use Date# instead of the Date-function.
The Date-function only formats the field as a date. Date# evaluates the field as a date with numeric representation and the result will be 10.

/Fredrik