How to calculate days between two dates

[Anonymous]

Hello,

I'm new in QV and I'm trying to calculate the different between two dates in days. What I have is a single field called REPORT_DATE formatted as DD/MM/YYYY and I need to calculate the difference between the first and the last record in days.

I have try the following:

interval(max(REPORT_DATE))-(min(REPORT_DATE))

but it doesn't return the right values.

Could anybody help me?

[sunny_talwar]

To get days you can just subtract them without Interval:

Max(REPORT_DATE) - Min(REPORT_DATE)