p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: Date/Time fields


Message #1 by btpoole@s... on Fri, 25 May 2001 15:06:27
I am creating a report from an Access database that contains 2 date/time 

fields. When I place the fields on the report, they are in the format 

yyyy/m/d hh:mm:ss (2001/05/25) 12:47:30. I need one of the fields to 

display only the date portion in the format mm/dd/yyyy and the other field 

to display only the time in the format hh:mm:ss am. I am using version 

4.5. For some reason Crystal has these fields as strings, not date/time 

fields like the database. I have checked the convert date/time box in 

options and report options. Neither checked or not checked will give me 

the results. Any help appreciated.

Thanks

Todd

  Return to Index