BAQ Calculate Days Between Dates

Epicor ERP 10
1

I’m trying to create a dashboard to measure our job performance, can anyone tell me how to calculate the number of days between 2 date fields? In excel you can just subtract one from the other but the BAQ does not allow that.

Thanks in advance

2

datediff(dd, date1, date2)

https://www.w3schools.com/sql/func_datediff.asp

1 Like
3

Thank you I was assuming the only functions available to me are the ones in the function box.

4

In all fairness I’d say that @jblomstedt deserves that solution.

1 Like