I have a crosstab whose column headings are derived from a Date/Time column in my table. I do not want to display the time portion of the value as it is irrelavent. No matter what Format changes I make, the format stays the same. I have also tried changing the format in FM model, but it too stays the same. Database is Oracle 10g.
Anybody see this problem before? Workarounds? Thanks,
Mark
Instead of changing the drop-down formatting options, enter MM/DD/YYYY in the pattern field and see whatcha get.
Regards,
mike
Thanks for the reply. Yeah, I tried that already too. Other things I tried included making it a Date/Time format and I chose NO for all the Display settings for Time... Display Hour = No, Display Minute = NO, etc...
Select the column title and change the Text Source -> Source Type propert from Member Caption to Data Item Value, then set the required Format
HTH
Gary