Hi Everyone,
I'm trying to pull in transactions between a range, but it's not the entire day. I'm looking to get transactions for a 48-hour period beginning at 4PM one day and ending at 4PM two days later. It's 4PM on 11/27 through 4PM on 11/29.
I've got the date range in the date filter selected. That was easy. Do I just add a timestamp to the end? If yes, how do I format that?
What you could do is create a pivot table the includes Transaction ID and Order ID. You then figure out the beginning and ending Transaction ID numbers that fit within your 48-hour window by loading the order and clicking on Order History to figure out the transaction time. You then add a filter on Transaction ID. Does that make sense?
This is a good idea, but it doesn't quite work for this situation since a lot of gifts that were received within the timeframe weren't entered until after. I can backdate the gifts on the gift date and the post date, but the transaction IDs will just carry on sequentially.