Discussion board where members can get started with QlikView.
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.
Go to 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])