Update Query to change Renew Dates

[GraemeG]

Hello.

I wanted to create an update query to enforce all Renew Dates within my fields are atleast the current year.

I have created the following - see picture.

But all it does it changes everything to "Date" text within the fields.
Can I create an update query to do such a thing. I.e. The Current field has records with 2010 in and i want to update them to say 2011(current year)

Any help much aprpeciated

[pbaldy]

If you meant to use the Date() function, it should not be enclosed in quotes. I'd probably use the Year() function instead of Format(), which will return a string.

[GraemeG]

If you meant to use the Date() function, it should not be enclosed in quotes. I'd probably use the Year() function instead of Format(), which will return a string.

Sorry not sure what you mean here.

So in the update query design:
Update to: Year("yyyy")?
Criteria: < year("yyyy")?

Sorry just another note. I was using the Format(Date, "yyyy") in my form for various things, as the field is a textbox not date.

[kennejd]

You'll notice that in the screenshot you attached that Access converted your function to Format("Date", "yyyy") ....which won't work. If you go with year(date()) or Format(date(),"yyyy") it should work ok.

[GraemeG]

You'll notice that in the screenshot you attached that Access converted your function to Format("Date", "yyyy") ....which won't work. If you go with year(date()) or Format(date(),"yyyy") it should work ok.

Great stuff - wow.

It worked a treat using:
Update to: Year(Date())
Criteria: <Year(Date())

Thanks.