0

Date-Time Filter

Jet Reports Historic Posts

July 09, 2013 13:12

None

Follow

I previously posted this as an addon to another topic but did not receive a response so figured I would create my own topic.

What I am looking for is to pull in time transactions from Date 1 4:00 AM to Date 2 3:59 AM. I am not sure how to create the date filter for this.

Currently I have =NP("DateFilter",$G$6,DATE(YEAR($G$6),MONTH($G$6),DAY($G$6+1)))&" 3:59 AM" which will give me the transactions from all of Date 1 to 3:59 AM of Date 2 (cell G6 is just Date 1).

Any help would be appreciated.
Thank you!

Mark

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts July 09, 2013 19:08 Official comment

  Hi Mark,
  
  Well you could probably use the Excel TEXT function and string concatenation to do this like this:
  
  =TEXT($G$6,"MM/DD/YYYY")&" 4:00 AM.."&TEXT(DATE(YEAR($G$6),MONTH($G$6),DAY($G$6+1)),"MM/DD/YYYY")&" 3:59 AM"
  Does this help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts July 10, 2013 13:58

  Thank you Hughes, it seems to work perfectly for the week of times that I ran. I do appreciate the help!