Dependencies End Date Sets to Previous Day?

Options

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

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭✭
    Options

    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

  • Dustin R
    Options

    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.
    Genevieve P. Employee
    Answer ✓
    Options

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now