Export to Excel date field

[#1]

Hi, I have a date type field that I load like:

If([Close date]='01/01/1900','', Date([Close date]))

The problem come when I export a table with this field to excel, the column in excel have text format instead date format. Can I load the date with a null value instead ''?

Thanks

[#2]

Make sure that in the chart properties, Close date, on the number tab, is marked as a date value:

[#3]

Yes, but this field is a dimension, not an expression...

[#4]

Hi,

Please Try with below Code

If([Close date]='01/01/1900',Null(), Date([Close date]))

Regards,

Joshmi

[Clever_Anjos]

Please remove your calculated dimension and use another strategy to filter your graph. It´s the best way

You can use a combination of Set Analysis/Supress Zeros to filter your object

[#6]

The thing is, that if you use, both text '' and date values, you will get a text field instead of a date field.

You could generate this dimension during the load script:

If([Close date]<>'01/01/1900', Date([Close date])) as [Close date]