Referencing specific date and time within formula

[Dara_Molotsky]

I need to be able to write a formula that checks if the last modified date is after a specific date and time. Basically, I imported a large batch of data and I want to track whenever a change is made after the specific date and time of import. I'm having trouble referencing the specific date and time of import within my IF(IS_AFTER) formula. Here is what I have so far - but I know AT isn't reading the date and time I referenced.

IF(IS_AFTER({Updated Post Initial Import}), '2023-07-14 120000', "Updated Post Initial Import")

[Manuel_Tanco]

Did the data you import create new records?

[Sho]

There seems to be a mistake in formula

IF(
  IS_AFTER(
    {Updated Post Initial Import},
    '2023-07-14 120000'
  ),
  "Updated Post Initial Import"
)

[Dara_Molotsky]

Thanks! This should work - but, it's showing every single record "updated post initial import" even when most are before 12:00:00 (11:58:07, etc). Is it due to timezones that this isn't reading correctly?

[Dara_Molotsky]

Yes - every record is new. Imported the whole data table.

[Dara_Molotsky · Accepted solution]

Yup - just figured it out, that was the issue.  Had to update formula to be in the same timezone as the import.

Updated to:

IF(
  IS_AFTER(
    {Updated Post Initial Import},
    '2023-07-14 160000'
  ),
  "Updated Post Initial Import"
)