Date select from form.

**BatmanMR287** · 01-21-2015, 04:37 PM

I have a query that checks the dates on policies to see of they are five years old or more.

<DateAdd("yyyy",-5,Date())
It works great. But, they want to be able to input the date to look backwards from instead of taking that current days date.
I tried <DateAdd("yyyy",-5,[Forms]![name of form]![text0])) and it didn't like it.
Any ideas?

**BatmanMR287** · 01-21-2015, 06:18 PM

Got it.
<DateAdd("yyyy",-5,[Forms]![name of form]![text0])
works great.

Date select from form.

Thread Tools

Date select from form.

Similar Threads

SQL If no value for current date then select next closest date

select from pop up calendar on a form and choose a date

query which run command: select records if date is out of date

Select Date Range

Using form combo box in query to select date.

Posting Permissions