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!
Solved
If Created date is within the the last 12hrs
+6Best answer by Kamille_Parks11
IF(
DATETIME_DIFF(NOW(), CREATED_TIME(), "hours") <= 12,
"yes",
"no"
)
+27IF(
DATETIME_DIFF(NOW(), CREATED_TIME(), "hours") <= 12,
"yes",
"no"
)
+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!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.