Partial Date Match/formatting error

[mpearson]

hello,
I am currently having issues matching a date from an oracle database to yesterday's date using the vba date function. If I run the macro I want it to search the spreadsheet for yesterday's date(friday's date if its a monday) and copy all of those rows into a new sheet. So far the code will find the date but I am having issues matching the dates. The date format from the sheet is '3/20/2013 11:00:00 PM' Thanks for any help.

Please Login or Register  to view this content.

[Norie]

It looks like your 'dates' are actually text.

You can check that using the ISNUMBER worksheet function with one of the cells with a 'date'.

If it returns FALSE then you have a text date.

Even if you do have actual date values then they appear to have a time part, PrevDay won't have that so won't match.

Are you able to filter the data manually?