I have a data entry form used to enter Lawn Treatment records. I want NSD (Next service date) feild to be updated to 3/15 current year, or 5/1 Current year etc. based on value entered into another feild called app no
as in If app no=1 then nsd= 3/15/Current year of If app no=2 then nsd=5/1/current year
I can use If app no=1 Then Nsd=3/15/2015 or If app no=2 Then NSD=5/1/2015, this will only work for current year, I would like for this to change each year.