Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I don't know why but when I make a crosstable it automatically recognizes my price field as a date
so instead of 150 I get a 40213 date value or something.
how can that be fixed?
thanks
Hi,
Upload your sample data excel for checking purpose
i found it.
reformat the whole sheet to general, and fix the date with Date(Num#(date_field)) AS Date afterwards