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

Alice_Elizabeth · April 11, 2018, 2:23pm

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.

Thank so much,
Alice

jhawt · April 11, 2018, 2:32pm

You will want to use this

dateadd(day, 7, POHeader.OrderDate )

Alice_Elizabeth · April 11, 2018, 2:36pm

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

Hogardy · April 11, 2018, 4:20pm

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