This ought to be easy. I want to display records on a calendar by a single date field, but the date field for display is calculated: It’s the DueDate if there is one entered, otherwise it’s CreatedDate.
IF( DueDate=BLANK(), CreatedDate, DueDate )
Dates in, dates out, right? Nope. A formula field using the above formula cannot be used in the calendar, apparently because the result of the formula is not recognized as a date.
Now the following DOES work:
DATETIME_PARSE(
DATETIME_FORMAT(
IF(DueDate=BLANK(),CreatedDate,DueDate),"MM/DD/YYYY"
),"MM/DD/YYYY"
)
Seriously? Is there not an easier way to do this?