query dates within query (1 Viewer)

[Bladerunner]

I am trying to run a query that among other items checks to see if the Birthdates field of a table Plus 150 Days is less that the present Date(). in the criteria area.


All are shortdate format and fields are DateTime. However, it does not seems to be recognizing the Date(). Since I don't need the time, I have not tried Now()

Question Can I convert the Birthdate field to a number thus allowing an easy arithmatic function to happen and check it against todays date.

Thanks

Blade

 

[pbaldy]

What is the SQL of your query? Using Date() should work. If you used the Format() function, that would make the result a string.

To your question, a date/time field is actually stored as a number (Double, where the integer represents the date and the decimal portion the time). Things like FieldName + 1 will work.

 

[Bladerunner]

Hi Mr. PBaldy: Thanks for your reply. I had been reading several problems that had arisen using the date() in Access and wondered why everything I read appeared to be complicated. There had to be a simpler way. Yes you are right, the Date() works. Guess I needed to get it in the right format.

Date()>[BirthDate]+150, Where Birthdate is the field name and 150 represents an extension of days. Thus a date of #4/2/2014# + 150 is still lower than todays date.

Thanks again

.

Blade.

 

[pbaldy]

Happy to help!