Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: If Created date is within the the last 12hrs

Solved
Jump to Solution
906 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Breight_Group
6 - Interface Innovator
6 - Interface Innovator

Hi Team, Looking for some assistance on a formula. I want to know if the created date and time is within the last 12hrs.

Thanks in advance!

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus
IF(
   DATETIME_DIFF(NOW(), CREATED_TIME(), "hours") <= 12,
   "yes",
   "no"
)

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus
IF(
   DATETIME_DIFF(NOW(), CREATED_TIME(), "hours") <= 12,
   "yes",
   "no"
)

@Breight_Group Did @Kamille_Parks provide the answer you were seeking? If so, please mark her comment above as the solution to your question. This helps others who may be searching with similar questions. Thanks!