I don't think this is possible, but maybe someone has an idea:
I have a date Field "DueDate". Sometimes the DueDate is unknown. I don't want to leave it blank, but to show a due date if one is known, and to show "Unknown" if not known. Is that possible somehow?
The closest I can think of is to have two Fields (DueDate and a Text Field with Known/Unknown)
Alternatively,
Use a text Field for the DueDate, but that will cause other issues.
How do I ?
Comments
If you use a sortable date…
If you use a sortable date format, such as yyyy-mm-dd, then using a text field works quite well. You can use auto-assign (or a row equation) to fill a true date field if you want