Dependencies End Date Sets to Previous Day?

Hi! We have noticed that when Dependencies are on, filling an empty End Date cell (when the Start Date and Duration are also empty) with a date results in a cell value the day previous to the intended set date. Is this intentional, or is this a bug?
Best Answer
-
Hi @Dustin R
You're correct - it's currently expected behaviour that if you're entering an End Date into a cell before adding any other information, it will adjust back one day for the reason's you've described. Here's another Community post where this is discussed: Why are selected dates displaying 1 day prior?
I would recommend adding in your Start Date first, then Duration, for the End Date to be populated as you'd like.
Cheers,
Genevieve
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Answers
-
Hi @Dustin R
Is the end date a weekend or a holiday that is set in the project setting or company wide working days setting?
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
No, the end date we are trying to set is not a weekend or holiday in the working days settings. However, if one attempts to set the end date to a Monday (for instance), it reverts to the previous Friday.
It appears that this behavior is related to the duration being set to a day (which is the automatic default from Smartsheet). It is possible to pre-set the duration before filling the end date, and if it is set to a period not evenly divisible by 8 hours the behavior doesn't occur. However, if it is any period evenly divisible by 8 hours, the start date and duration are automatically filled to the previous day's date, and then the end date updates to the previous day's date a few milliseconds later (it is visible).
At this time I believe there is a rounding error bug in the Smartsheet code that is causing this to happen.
-
Hi @Dustin R
You're correct - it's currently expected behaviour that if you're entering an End Date into a cell before adding any other information, it will adjust back one day for the reason's you've described. Here's another Community post where this is discussed: Why are selected dates displaying 1 day prior?
I would recommend adding in your Start Date first, then Duration, for the End Date to be populated as you'd like.
Cheers,
Genevieve
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives