Time format displayed on a Report

[saran26]

Hi All,

My query which i used for the report shows the time on CST format, but my report shows it in GMT format is it possible to convert it into CST.

please let me know.

Thanks
Saran

 

[beltmanjr]

Why not simply right click the field in crystal and select to format it. In there you should find a 'date and time' tab where you can specify any date time formatting you like.

 

[saran26]

Hi ,

I tried that I dont see the where we can specify the Time - Zones ?

Do you know where I can specify that ?

Thanks
Saran

 

[beltmanjr]

SO, what is it ylu are after? Is it displaying CST + X = GMT time or is it the formatting? If so, what formatting are you after? And are you certain it is a datetime?

Try a test formula like: cdatetime('2008-12-31 23:59:01')
and format that field.