I’m trying to exclude (NotNull) from a Date field,

[TheRoo]

I’m trying to exclude (NotNull) from a Date field, although I can do it by:

= If (isnull(YourExpression),0,YourExpression), unfortunately it is converting all the other dates into just numbers, so in a nutshell how do a write the script to covert the number into ‘DD-MM-YY’

[Vegar · Accepted solution]

Format your output as a date

= If (isnull(YourExpression),0,date(YourExpression, 'DD-MM-YY') ) 

[tomovangel · Accepted solution]

Hello, easiest way is to do this
Date(If (isnull(YourExpression),0,YourExpression),'DD.MM.YYYY')

[TheRoo]

Tack, det fungerar nu

[TheRoo]

Thank you