datetime stamp in table not showing time in report.

[jcisco]

I have a small problem. inside my table i have a col called EndTime which is a datetime stamp. now then when i bring this table in my crystal report and drop the value on the report it will only show the date not the time. when i go into the Format field of that obj the only options that i have are for date no time. I know that there is a setting to add the time to this but i can't remember where. can someone point me out in the right direction.

cheers
john

--------------

 

[synapsevampire]

I think that it's under File->Report Options

Either that or File->Options

The top area has convert datetime to <choice>

Of course this is Crystal version dependent, consider posting basic information when requesting technical assitance.

-k

 

[jcisco]

crystal ver 8.5.0.218

under file options I go to reporting and i have changed the Conver Date-Time Field: to equal To Date-Time

then in the Fields tab I have picked the Style that I would like to show up on my Date/Time objects 3/1/99 2:01 pm then i clicked ok. the Ok again to close the options screen.
I removed the field object, and readded it to the report. then when i go into the editor and click on the date/time tab it still only shows the dates no times. I double checked the table in SQL and there is a time appened to the date.

suggestions?

--------------

 

[jcisco]

got it. i had to select the second to the top option for it to work.

--------------