Time Range Selection

Wed, 24 Aug 2011 01:15:31 GMT

Hi,

i face some datetime issue where records query from SQL server.

i get the format like this

4/25/11 1:15 PM

Year(ExitDatetime) AS ExYear,
Month(ExitDatetime) AS ExMonth to get Month and Year.

The issue i facing now is how can i get only Time only instead ?

and after that i would like to do a time range selection for it. to filter data.

example :

01:00 am - 02:00 am

02:00 am - 03:00 am

...

for the date, it's posible to get what day is it?

example :

8/24/11 is Wednesday

8/25/11 is Thursday

Therefore i able to set the range as well.

Sunday

Monday

...

I sincerely here to look for some guide and exapmle for achieveing this.

Million Thanks.

topic Time Range Selection in QlikView