Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

valueexpression not calculating correctly

Avatar

Level 1
One of our users created a report to calculate the date 23 days after the date field "Vendor due date" by using valueexpression=ADDWEEKDAYS({project}.{DE:Vendor due date},23). It has been working fine but calculated one value that was a weekend. Any ideas on what could be going wrong? Thanks in advance! Madison Schanbacher Ferguson Enterprises, Inc.
3 Replies

Avatar

Level 10
Do you remember what date gave you the Weekend answer? I can try it in my instance. Anthony Imgrund FCB

Avatar

Level 1
Thanks Anthony! It was pulling from 4/15/20 and the date that it calculated was 5/17 Madison Schanbacher Ferguson Enterprises, Inc.

Avatar

Level 10
I'd contact Support. I did a test and it goes to the Monday for me Anthony Imgrund FCB