Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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])
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])