what is 1.8 in this expression.
I have seen people using now() + (-1.8) or now() + (1.8) for making 24 hours difference.
What exactly is 1.8
2
-
1Can you provide a specific reference to a link or document that demonstrates this? I can't say I've ever seen this specifically.– sfdcfox ♦Commented Mar 6, 2018 at 6:54
-
This formula LastModifiedDate >= now() + (-1.8) returns true if LastModifiedDate ranges from last 24 hours– CloudDotCommented Mar 6, 2018 at 7:01
Add a comment
|
1 Answer
Date and time arithmetic is explained in this help article: https://help.salesforce.com/articleView?id=formula_using_date_datetime.htm&type=5
The value indicates the difference in number of days, hours, and minutes. The quantity to the left of the decimal is the number of days, and the quantity to the right is the fraction of a day.
The value of 1.8 doesn't make any sense for a 24-hour difference, so you need to post more details about your formula and if it actually works.
answered Mar 6, 2018 at 7:02
-
Exactly am not understanding the origin of 1.8 here, but it happens to be working when i checked. For ex :LastModifiedDate >= now() + (-1.8) returns true if LastModifiedDate ranges from last 24 hours– CloudDotCommented Mar 6, 2018 at 7:05
-
What if LastModifiedDate is in the last 36 hrs, does the formula return true? Commented Mar 6, 2018 at 20:30
-