Jump to content
  • 0

Calculated Field - Count, Datepart


LWSChad
 Share

Question

Hello All,

I would like to COUNT the values between a certain time frame regardless of date... for this example lets say 10AM and 4PM or 10:00 and 16:00.

 

Please consider:

Item1: 01/07/15 11:00:00

Item2: 01/04/15 13:00:00

Item3: 01/03/15 07:00:00

Item4: 01/06/15 17:00:00

Item5: 01/03/15 09:00:00

Item6: 01/07/15 15:00:00

 

Desired results: 3

 

 

 

I can pull the hour from the date, but I can't figure out how to filter by hour or count values in a range.

 

Any ideas?

 

Thanks

 

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...