AnsweredAssumed Answered

subsummary by hour from timestamp

Question asked by drrwinters on Dec 21, 2009
Latest reply on Dec 21, 2009 by comment_1

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 

 

 

Outcomes