Dates don't match?

RossL ✭✭✭✭✭✭

I have a system date and a column that is pulling just the date out of it with a date formula. for items that are created later in the night it is showing the next day before 12pm local time.

is this because of the UTC issue?


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 02/06/21

    Hey @RossL

    Yes, it is because of the difference in your timezone and UTC-0. A work around is to use the new automation Record a Date and trigger off of the the Created field changing to any value. The date that is captured by Record Date is in your local timezone. The time of the Created timestamp is already in your local time, if you needed to extract that.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!