We have a Microsoft Access database utilized to track the implementations / instruction changes related to Lockbox accounts. There is a 'date' field (IMTS Date) that when populated should trigger another 'date' field (Tech Spec Signoff Due Date) to be populated automatically. The IMTS Date field has an Input Mask of dd/mm/yy and the Tech Spec Signoff field does likewise. The Tech Spec Signoff Due Date is always 5 business days after the IMTS Date. Does the use of the Input Mask nullify the ability to utilize functions such as DateAdd? Are we approaching this issue in the right manner?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Access DateAdd function
- Thread starter TheREB
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question