Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

If Created date is within the the last 12hrs

Topic Labels: Formulas
Solved
Jump to Solution
300 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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
IF(
   DATETIME_DIFF(NOW(), CREATED_TIME(), "hours") <= 12,
   "yes",
   "no"
)

See Solution in Thread

2 Replies 2
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!