Format DateTime Value in Cross-Tab Report

[thelittleone]

Hi All,

I am attempting to create a Cross-Tab report with a datetime value as one of the measures. Upon adding the query item to the measure and modifying the Data Format type to Date, the value continues to display as 20,041,217. I would like the date value to display as 2004/12/17.

Thanks in advance,

TheLittleOne

 

[GilMerc]

HI,

You must use a function DateTime_To_Date in a calculation field.

Gilles.