For example, if i want to populate a date formula field, I would use the DATE(year, monty, day) formula. However, no function seems to be intented for date time (e.g. DATETIME(year, month, day, hour, minute, second, timezone)
Does anyone have any idea without using apex?
2 个回答
are you looking for this? DATETIMEVALUE
Description: Returns a year, month, day and GMT time value. Use: DATETIMEVALUE( expression ) and replace expression with a date/time or text value, merge field, or expression. Example: Closed Date
DATETIMEVALUE(ClosedDate) displays a date field based on the value of the Date/Time Closed field.
Literal Date Value
DATETIMEVALUE("2005-11-15 17:00:00") returns November 15, 2005 5:00 PM GMT as a date and time value .
Tips:
- DATETIMEVALUE is always calculated using GMT time zone and can't be changed.
- When entering a date as a literal value, surround the date with quotes and use the following format: YYYY-MM-DD, that is, a four-digit year, two-digit month, and two-digit day.
- If the expression does not match valid date ranges, such as the MM is not between 01 and 12, the formula field displays #.ERROR!
