MACRO - IF Statement to evaluate if Date falls BETWEEN to Dates - Please help.

Totnumfound is being displayed on the sheet but is used in multiple loops through multiple arrays to generate multiple reports on a number of sheets. I'm adding this If statement to evaluate on date so that I can run the report for a particular date period instead of a 'snapshot' showing all records.

The If statement does not fail but does not evaluate properly. The >= and <= should resolve to "between dateA and dateB" but for some reason excludes the records <= dateB.
I just need someone to help me figure out why this is happening or alternatively correct the statement to work properly.

PLEASE HELP!

Hey Guys. I thought this would be a simple code fix. I have seen some impressive code on this forum and didnt think it would take long for someone to correct my code. Is there truly no one who can help with this.

I am not 100% on best way to solve this, but a possibility of making this easier could be to change the date formatting. If you read up on this page on ozgrid you will see what I mean:

http://www.ozgrid.com/VBA/find-dates.htm

Originally Posted by mtt23

I am not 100% on best way to solve this, but a possibility of making this easier could be to change the date formatting. If you read up on this page on ozgrid you will see what I mean:

http://www.ozgrid.com/VBA/find-dates.htm

Thanks. I will see if this is a factor.

I managed to get it to work. I declared a starttime and endtime variable and assigned them the static values of 12:00:00 AM and 11:59:59 respectively. So I now had four separate variables for start date/time and end date/time all declared as date. I then tried to combine them into a single variable for start SDATETIME and end ENDDATETIME which I used in my IF Statement. This kept failing however though I tried many variation and also using CDATE. Finally it struck me that I should declare all the variables as string and then use CDATE in the IF Statement to convert the combined date/time string to a date. That finally worked.

code is below in case anyone is interested.

Please Login or Register  to view this content.

@ tdguy09

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.