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

Answers

  • AravindGP
    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?

    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.

  • Genevieve P.
    Genevieve P. Employee
    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