Dates don't match?

RossL
RossL ✭✭✭✭✭✭
in Formulas and Functions

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?


image.png


· Share on FacebookShare on Twitter

Answers

  • 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.

    Kelly

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!