Match field value

[nareshthavidishetty]

Hi,

I have a date entry in my [calendar date ] as '31-12-1999 00:00:00'.

I need to make this entry to 'No Date'  at script level.

Thanks..

[techvarun]

Try "Map Using" table

[mdmukramali]

Hi,

If(Match([calendar date ] , '31-12-1999 00:00:00'),'No Date',[calendar date ]) as [calendar date ]

OR
If([calendar date ]='31-12-1999 00:00:00','No Date', [calendar date ]) as [calendar date ]

Thanks,
Mohammed Mukram

[tresB · Accepted solution]

This value is actually equivalent to 366. So, if you really have dates in the field (not strings), you could try like:

If (num([calendar date])=366, 'NoDate', [calendar date])