1 Reply Latest reply on Dec 21, 2009 12:48 AM by comment_1

    subsummary by hour from timestamp

    drrwinters

      Title

      subsummary by hour from timestamp

      Post

      I would like to create a subsummary of the transactions that occur during each hour from a timestamp.

      Using Filemaker Pro 10.

       

      For example,

       

      11 AM 

        Transaction1 12/20/2009 11:15 AM

        Transaction2 12/20/2009 11:45 AM

      12 PM

        Transaction3 12/20/2009 12:25 PM

      1 PM

        Transaction4 12/20/2009 1:05 PM

        Transaction5 12/20/2009 1:45 PM

        Transaction6  12/20/2009 1:55 PM

       

      I've tried GetAsTime(Timestamp) with result as Time and changed to display as 11 AM.

      I get:

       

       

      11 AM 

        Transaction1 12/20/2009 11:15 AM

      11 AM  

        Transaction2 12/20/2009 11:45 AM

      12 PM

        Transaction3 12/20/2009 12:25 PM

        ...

       

      What additional step am I missing?

      Is there an elegant solution?

      Should I just extract as a calculation the hour and AM from the timestamp as text into a new field and then subsummary from that?

       

      Thanks!

       

      Richard