Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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