Dates based on todays date

[cav]

I have a criteria in a query to bring up employees hired 30 or more days ago.  <=Date()-30 in the hire date field.  It works on my machine at home but not the one at work. I get the error "Expression is typed incorrectly, or it is too complicated to be evalllluated....etc. Any idea how to fix this problem.  Thanks...

 

[Guest_imported]

You need to update your references<br>Open a new module<br>under tools click references<br>then select a reference that is not checked or one that is<br>hit ok<br>select tools references again and uncheck the same item you just did. then select ok again

 

[famousb]

you may also want to try <br><br><b>&lt;(Date()-30) OR =(Date()-30)</b><br> <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[cav]

Both suggestions were useful! Thanks so, so much.