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 help? 👀 | 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| Principal Consultant
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 help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives