Subtracting dates in BAQ calculated field?

I am moving BAQs over from E9 to E10, and this is the logic for the E9 calculated field I’m trying to duplicate.

(integer(ShipHead.ShipDate) - integer(OrderRel.ReqDate))

When I use that exactly in E10, I get the error 'integer is not a recognized built-in function name.
I already tried simply exporting the BAQ and importing it in E10, it worked for most, but this one said ‘Bad SQL Statement’ so I am rebuilding it. If you have another suggestion that would help also.

Thanks,
Logan

image

3 Likes

You’re the man, @Banderson !
Worked!
Thanks!

Just remember that almost anything in SQL works in the calculated fields, so if you google SQL and whatever you are trying to do, 9 times out of 10, you can type it in. Luckily SQL is very well documented too, and lots of answers online.

2 Likes

Awesome!