expiry date (edit)

[goju]

I have a issue date and an expiry date feilds,

the below script in my query is to automatically increase the date by one year, this works fine but i would like to be able to back date the script if necassary.

i have checked the properties and the field is not locked. but it wont let me change the date.

any ideas

Expirydate: DateAdd("m",12,[Issueddate])

 

[Mile-O]

For one, that isn't going to change anything by a year.

 

[goju]

well it works the expiry date returns a date of 1 year form the issue date

any ideas about editing

 

[Mile-O]

Sorry, I misread, although: DateAdd("yyyy",1,[Issueddate]) is more appropriate for one year.

OKay, what do you mean by "backdate" in this instance?

 

[KevinM]

You won't be able to edit an expression in a query.
You will have to invoke the DateAdd fuction on a form by other means like a command button (or maybe as a 'default value' )and leave the Expiry Date field as it is, so you can edit it.

I assume yoy do have an expiry date field in your table and not just as an expression in a query?