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!!!!!!!
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!!!!!!!
Last edited by shralpy; 12-01-2011 at 03:41 PM. Reason: backwards
its DateAdd("yyyy",2,[Textbox1])
Thanks hertford but actually i mislabeled on this thread I have DateAdd for expression
TextBoxA contains a string instead of a datevalue? In which case you need to use a function to convert TextBoxA to a datevalue.