Hi
I am storing some data with date+time thr' VB in MS access table in format like 13/02/2009 7:15:00 AM
and using Crystal report 8.5 to generate report.

When I browse the .MDB data from a date field , it shows only date and not showing time.

Now I am able to create a date wise report correctly.
But I want a date+time wise report i.e. Shift wise report (7.00 AM - 3.00 PM & 3.00 PM - 11.00 PM etc).

Can anyone help me in
How to set the datetime format in crystal report. i.e. " dd/mm/yyyy h:mm:ss AM/PM " in formula editor ?
How to pass the date+time parameters from VB to crystal
reports as a filter to create date+time wise report?

Thanks in advance...

Rahul B.