0 Replies Latest reply: Aug 23, 2011 9:15 PM by Jeffrey Chan RSS

    Time Range Selection

      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.