Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

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