I have a database that contains a column with data in the format "m/d/yy h:mm:ss;@". Sometimes the time is N/A due to user input, which is necessary for this application because there is not always a time associated with the date. I have to have the time and date in the same cell, they cannot be in separate cells due to the way they need to be filtered for printing.
When I try to use AutoFilter with the above format, it from left to right on the tree for all values that do not contain N/A the way it should, but then any days that have the time as N/A are listed at the bottom as "4/1/13 N/A" and "4/2/13 N/A" etc. So the filter tree works like this: Filter year Filter month Filter day Filter hours Filter minutes then at the bottom the dates with N/A are listed and cannot be expanded or anything. Basically I want the filter to be: Filter year Filter month Filter day Filter hours AndOr N/A If hours Then Filter minutes.
Is this possible or do I need to go about this another way?
This database is a list of events that are entered via a userform, I want to be able to filter through several hundred events by date and time, so that every day a report can be printed containing events from 0500hrs the day before to 0500hrs current day. I can do this now by manually choosing the right filters and by having the date and time in separate cells but I want to automate it as much as possible.
Thanks in advance for the help, sorry it's so long...
When I try to use AutoFilter with the above format, it from left to right on the tree for all values that do not contain N/A the way it should, but then any days that have the time as N/A are listed at the bottom as "4/1/13 N/A" and "4/2/13 N/A" etc. So the filter tree works like this: Filter year Filter month Filter day Filter hours Filter minutes then at the bottom the dates with N/A are listed and cannot be expanded or anything. Basically I want the filter to be: Filter year Filter month Filter day Filter hours AndOr N/A If hours Then Filter minutes.
Is this possible or do I need to go about this another way?
This database is a list of events that are entered via a userform, I want to be able to filter through several hundred events by date and time, so that every day a report can be printed containing events from 0500hrs the day before to 0500hrs current day. I can do this now by manually choosing the right filters and by having the date and time in separate cells but I want to automate it as much as possible.
Thanks in advance for the help, sorry it's so long...