Skip to Content
avatar image
Former Member

get time from timedate field

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 04, 2008 at 08:48 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 10:34 AM

    Thanks Ramesh, works like a charms!!

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

    to allow ranges to be set up.

    Add comment
    10|10000 characters needed characters exceeded