How to replace the date 31/12/1899 with an empty string in an Active Form- Please help

[perj]

Hi Team,

I am getting the value as '31/12/1899' in an active form for the date row.

Is there any way to remove this value with the an empty string using the formatting option of an Active Form?

Kindly help if you come across of anything.

Thanks.

[declanr]

You just need to utilise the excel formatting.
First option is for a positive value, second a negative and third a zero or blank.

So "dd-mm-yyyy;;" will return blanks where the date is zero (and if you somehow ended up with a negative date.)