PRE SALE QUESTION FOR Report builder. can the report(s) calculate days between dates, suppose that I add a template that has a formula to caculate days between dates, if one date is "current date" in the Excel template ?
OR, any solution as to how I could calculate days between dates?
Unfortunately, this can't be done out-of-the-box with the plugin. Our Formula columns can only calculate numerical data (integers and floats), but it can't calculate a date difference.
You can, however, create an SQL query-based table, where you would use DATEDIFF() function to calculate this and then use the Report builder to pull that information from the table.
PRE SALE QUESTION FOR Report builder. can the report(s) calculate days between dates, suppose that I add a template that has a formula to caculate days between dates, if one date is "current date" in the Excel template ?
OR, any solution as to how I could calculate days between dates?
Hi David
Thank you for reaching out to us.
Unfortunately, this can't be done out-of-the-box with the plugin. Our Formula columns can only calculate numerical data (integers and floats), but it can't calculate a date difference.
You can, however, create an SQL query-based table, where you would use DATEDIFF() function to calculate this and then use the Report builder to pull that information from the table.