Hello,
I apologize for asking this question as I am sure it is very basic but I am trying to figure out what it is doing...I am looking at a query and in that we are pulling in the "Audit Due Date" field and in the criteria for that field, it says "Between Date() and Date() +30"... the query runs well I just don't understand it...
I know Date() means today's date right? So it would pull in dates that are equal to today plus the "and Date()" this is what I don't understand and I am getting more data that those the just equal today's date...
I know that the +30 will add 30 days to that date...
I appreciate any help, thank you.
Lilly
I apologize for asking this question as I am sure it is very basic but I am trying to figure out what it is doing...I am looking at a query and in that we are pulling in the "Audit Due Date" field and in the criteria for that field, it says "Between Date() and Date() +30"... the query runs well I just don't understand it...
I know Date() means today's date right? So it would pull in dates that are equal to today plus the "and Date()" this is what I don't understand and I am getting more data that those the just equal today's date...
I know that the +30 will add 30 days to that date...
I appreciate any help, thank you.
Lilly
Between Date() And Date()
