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({ :bellhop_bell: 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 ?
