Skip to main content
Solved

If Created date is within the the last 12hrs

Breight_Group
Forum|alt.badge.img+6

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!

Best answer by Kamille_Parks11

IF(
   DATETIME_DIFF(NOW(), CREATED_TIME(), "hours") <= 12,
   "yes",
   "no"
)
View original
This topic has been closed for replies.

2 replies

Kamille_Parks11
Forum|alt.badge.img+27
IF(
   DATETIME_DIFF(NOW(), CREATED_TIME(), "hours") <= 12,
   "yes",
   "no"
)
    Justin_Barrett
    Forum|alt.badge.img+21

    @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!

      Terms & ConditionsAccessibility statement