get time from timedate field

[Former Member]

Hi there,

i am trying to make a report in crystal whereby i can filter the information by date and by time, so that i can say show figures from 01/08/08 to 07/08/08 but then narrow down to 09:00 to 11:00.

the problem i have is the date and time is stored as one field in my database.

is there a way to extract the time from the field to be able to set a time paramter and filter by it?

thanks

[Former Member]

Thanks Ramesh, works like a charms!!

i used the time(table.field) in ?starttime to ?endtime

to allow ranges to be set up.

[Former Member]

If you give formula as time({tablename.field}) it will give only time .

.

you can create a parameter field selecting parameter type as "time" from your datetime column also without using formula.

Regards,

Parsa.