Syntax on calculated BAQ field - add (x) days to date


(Alice Elizabeth Smith) #1

Hello all,

Can anyone tell me why my syntax doesn’t work below? Trying to create a calculated field that adds “x” days to POheader.OrderDate based on vendorID. I was thinking I needed to use “case” to achieve this.

image

Thank so much,
Alice


(Jason Hawthorne) #2

You will want to use this

dateadd(day, 7, POHeader.OrderDate )


(Alice Elizabeth Smith) #3

Thank you. Works great. Saved me lots of time.


(Pierre Hogue) #4

Dateadd works yes…but it does not take into account business days…vs weekends and holidays… anyway…in our version of Epicor it does not.

Is version 10.2 have the functionality of reading the business calandar set into Epicor in order to provide valid “workings” days to add to current date ?

Pierre