You are here:
NOW
Returns a date/time representing the current moment.
Use
NOW()
Tips
- Do not remove the parentheses.
- Keep the parentheses empty. They do not need to contain a value.
- Use a date/time field in a NOW function instead of a date field. Created Date and Last Modified Date are date/time fields whereas Last Activity Date is a date field.
- Use TODAY if you prefer to use a date field.
- Dates and times are always calculated using the user’s time zone.
- Use addition and subtraction operators with a NOW function and other date/time fields to
return a number representing a number of days. For example
NOW() - CreatedDatecalculates the number of days since the created date of a record. In this example, the formula field data type is a number. - Use addition and subtraction operators with a NOW function and numbers to return a date and
time. For example
NOW() +5calculates the date and time five days ahead of now. In this example, the formula field data type is a date/time.
Open Lead Example
IF(ISPICKVAL(Status, "Open"), ROUND(NOW()-CreatedDate, 0),
null)
This formula checks to see if a lead is open and if so, calculates the number of days it has been open by subtracting the date and time created from the current date and time. The result is the number of days open rounded to zero decimal places. If the lead is not open, this field is blank.
Did this article solve your issue?
Let us know so we can improve!
