Date expression

[shralpy]

I am trying to get textboxB to automatically be valued at two years from textboxA but its not working??????



This is the expression I am using for event afterupdate:

[textboxB]=AddDate("yyyy",2,[textboxA])

HELP!!!!!!!

[hertfordkc]

its DateAdd("yyyy",2,[Textbox1])

[shralpy]

Thanks hertford but actually i mislabeled on this thread I have DateAdd for expression

[hertfordkc]

TextBoxA contains a string instead of a datevalue? In which case you need to use a function to convert TextBoxA to a datevalue.