Date format in QS chart

[davyqliks]

Hi,

I have a simple issue i think...

in a chart if i have a dimension as [expiry Date] i get the correct date format (DD/MM/YYYY).

but, i have some blanks i want to name as N/A

so i add the following:

=if(isnull([Expiry date]),'N/A',[Expiry date],)

this works and adds the N/A but i have the number in num format and there is no place i see in the chart settings to change to Date format.

Can anyone assist please?

Thanks again

[sonkumamon · Accepted solution]

Hi,

Please try

=if(isnull([Expiry date]),'N/A',Date([Expiry date],'DD/MM/YYYY'))

[davyqliks]

So simple.....I just couldn't get the syntax right.

Thanks