I currently have a query in Excel that the date is being changed manually each month. I would like the code so that the date will be based on the today's date so the code will not have to be changed.
I would like to check DATEA is within the last 12 months
I would like to check DATEB >= today and DATEB is < today +1 (essentially = to today, but because the query uses both parameters I would like to leave the option for a range.