TM1 Forum

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.

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.)