BAQ Calculation

Epicor ERP 10
1

I am having trouble with the correct syntax for PartTran.TranDate - @Today

In E9 it was simply: PartTranUsage.TranDate - Today

I am trying to return the number of days from the last transaction to today. Any suggestions from anyone?
Thanks in advance!

Carol

3

DATEDIFF(d,PartTran.TranDate,GETDATE())

should do it. You can use the Epicor TODAY constant instead of GETDATE() if you like.

1 Like
4

Thank you for the help!

5

Thank you for the help … I so appreciate the timely response!

Carol