Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
To get days you can just subtract them without Interval:
Max(REPORT_DATE) - Min(REPORT_DATE)