Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Make sure that in the chart properties, Close date, on the number tab, is marked as a date value:
Yes, but this field is a dimension, not an expression...
Hi,
Please Try with below Code
If([Close date]='01/01/1900',Null(), Date([Close date]))
Regards,
Joshmi
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
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]