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?