In an OnInsert macro I want to set a local variable to a date one day previous to the date in the current item being inserted.
Table is Absences, date field is AbsenceDate. AbsenceDate type is short date.
Variable will be used as a parameter to a Data Macro.
Table is Absences, date field is AbsenceDate. AbsenceDate type is short date.
Variable will be used as a parameter to a Data Macro.