Filtering out dates using autofilter

  • Thread starter Thread starter sk8rider
  • Start date Start date
S

sk8rider

Please give me an idea on how to proceed with the following issue:

I would like to write a sub to perform the following:

My sheet has few columns (12), the last column is the date (YYYY-MM-DD
where an item was written in my database.

If the item was written today it only shows the time(HH:MM:SS). When
run my daily report I would like to filter for only those items entere
today(HH:MM:SS).

In short I would like to filter out anything that is equal to thi
format: YYYY-MM-DD.

Any help would be greatly appreciated
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with date formatting 5
date comparison 2
Autofilter Criteria not filtering when using NOW() 16
Autofilter in a macro 1
Excel is changing date format incorrectly 7
Date type 2
Today's Date 1
How to convert serial date&time to normal date&time? 2

Back
Top