J
Junior
Trying to set expiration date field 60 days forward from today
The code below works and sets Exp.dte one year ahead
How can i change it to set Exp.Dte 60 days ahead?
thanks
strSQL = "UPDATE tblDate SET tblDate.InstDte = " & strCurrentdate & ",
tblDate.LastUsed = " & strCurrentdate & ", " & _
"tblDate.ExpDte = #" & Format(DateAdd("yyyy", 1, Date),
"mm/dd/yyyy") & "#"
dbs.Execute strSQL
The code below works and sets Exp.dte one year ahead
How can i change it to set Exp.Dte 60 days ahead?
thanks
strSQL = "UPDATE tblDate SET tblDate.InstDte = " & strCurrentdate & ",
tblDate.LastUsed = " & strCurrentdate & ", " & _
"tblDate.ExpDte = #" & Format(DateAdd("yyyy", 1, Date),
"mm/dd/yyyy") & "#"
dbs.Execute strSQL