Jump to content
  • 0

Calculated Field - Count, Datepart



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?




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.

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.

  • Create New...