Skip to Content
Aug 28, 2012 at 01:20 PM

How Do I Calculate the Difference Between Two Dates?


I'm creating a new custom query that will be used for a new custom report. I would like to calculate the difference between two dates and display the difference as a result field on my query.

The two dates are RFx Base Date (FCI_RFX_DOC-BASE_DATE_DATE) and RFx Response Date (FCI_RFX_RESPONSE-FIRM_DATE_DATETIME).

Note: The WHERE clause in the SELECT statement ensures that I'm only evaluating firm responses. So, the RFx Response Date will always be populated.

Does anyone know how I would calculate the difference in days between these two dates and display the result as a result field in my query?

Thanks, Scott