Checking for date in msquery in Excel
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.
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.
Who is Participating?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
=INT(NOW())
Use the INT function to force the time to midnight (zero hour).