on 09-04-2008 8:42 AM
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
Thanks Ramesh, works like a charms!!
i used the time(table.field) in ?starttime to ?endtime
to allow ranges to be set up.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.