Date in Form 1

[Rjconrep]

I have a field where I input a date. Based on that date I want another field to add a day to the date.

 

[BillPower]

Try this:

MyDate2 = DateAdd("d", 1, MyDate1)

Mydate1 is the input field, rename to yours.
MyDate2 is the other field, rename.

To test it put the code into the "afterupdate" event in MyDate1.

 

[Rjconrep]

That is perfect.
Thanks a bunch!

 

[Rjconrep]

Now I have another dilemma. I need the field that gets updated based on the first fields value to update to the following Monday if the value in the original field is Friday.
In other words I need the program to skip weekends and default to the following Monday.

 

[chrissie1]

If Weekday(mydate1, vbSunday) = vbFriday Then
mydate2 = mydate1 + 3
Else
mydate2 = mydate1 + 1
End If
"What a wonderfull world" - Louis armstrong

 

[Rjconrep]

Once again, I thank you!