This code is used to calculate from Monday to the next Monday.
Starting with the closest Monday from today's StartDate in tblSchedules
The date could be Null if nothing has been scheduled, else start from the last StartDate and advance from there.
This is being used on a Continuous form.
tblSchedules
SchedID PK
StartDate Date/Time
Me.StartDate = DateAdd("ww", 1, Nz(DMax("StartDate", "tblSchedules"), Date)) The above code display this result 4/4
should be 3/30 next Closest Monday
Starting with the closest Monday from today's StartDate in tblSchedules
The date could be Null if nothing has been scheduled, else start from the last StartDate and advance from there.
This is being used on a Continuous form.
tblSchedules
SchedID PK
StartDate Date/Time
Me.StartDate = DateAdd("ww", 1, Nz(DMax("StartDate", "tblSchedules"), Date)) The above code display this result 4/4
should be 3/30 next Closest Monday
Calculate Next Monday
0 commentaires:
Enregistrer un commentaire