Created Date Issue

George Lie
George Lie ✭✭
edited 06/14/22 in Add Ons and Integrations

hi guys, as you guys can see, the Check-in Column is a Created Date column, the left date is the date I pulled from created date =Check-in@row, but apparently it shows the previous date if my employee scan under 6-7 a.m

Answers

  • Hi @George Lie

    System Date columns store date stamps as UTC, or GMT (although it can display the value in your local time).

    This means that a formula looking at that cell will bring through the date value based on GMT, which is likely why you're seeing inconsistencies.

    However, the Record Date Automation is based on local time! You could select a change in the Created column as your trigger, which only happens when the row is created. I would suggest using this workflow to populate a different date column, then reference this in your Start date column... or use it instead-of your Start date column? See: Set the Current Date with Record a Date Action

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions