Dependencies End Date Sets to Previous Day?

Dustin R

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?

Genevieve P.

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

AravindGP

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?

Dustin R

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.

Genevieve P.

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