Search results

The problem with this is the same as the LAST function, these are stored tables and I am pulling this information after the fact, so the MAX brings me the same result as the current visit. So I get my latest visit result and that same date as my prior store visit. I am not sure if I am making...

Hello all. I did not see a similar topic posted, but I have a bit of a tough query I am trying to figure out. I have a list of say customer visits, and they may have visited one of 7 store sites on any particular visit. I want to know for that customer what their last visit date was for that...