I’m using formula to create a date field, which is used in Calendar view as a calendar’s source. My problem is to create empty date, if certain criteria is occured. I try to use BLANK(), but this returns it in non-date format.

Here is the formula:

SWITCH(UPPER({ Agenda Status}),

“PENDING”, IF({Scene Setup date}, {Scene Setup date}, {Due Date}),

“SETUP”, IF({Scene Draft date}, {Scene Draft date}, {Due Date}),

“SKETCH”, IF({Scene Draft date}, {Scene Finalize date}, {Due Date}),

“DRAFT FOR REHEARSAL”, IF({Scene Finalize date}, {Scene Finalize date}, {Due Date}),

“FINAL FOR SHOW”, IF({Scene Show date}, {Scene Show date}, {Due Date}),

“CANCELLED”, BLANK(),

“COMPLETE”, BLANK(),

“REISSUE”, TODAY(),

IF({Due Date}, {Due Date}, TODAY())

)

Note, formula works, but this does not allow to set field formatting as date.

Is there a way return empty date in formula, so that field is in date format and not string ?