Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: LauraLaceyHello - I'm trying to cross reference 2 files based on dates but I need the check on the 2nd pin date to look between 2 dates is that possible?
File 1 = I have Travel start date and Travel end date
File 2 = I have hotel check in date
I need to find out if there was a hotel check in between the 2 travel dates.
Hope that makes sense?