I know I can add dateadd (d,<<number of days forward>>, <<date to add to(ie. NOW for current date)>>)
so: dateadd (d,1,now) to make it show the date on the form as tomorrow.
What I need to know is how to tell it to check the date, realize its tuesday, wed, monday, whatever, and automaticlly...
Im working on a form for work .... I have limited Access experience BTW .... anyway, what I am trying to do is when an employee access a new form there is a field for Week End Date ---- is there anyway I can automaticlly populate this field with the end date given certain criteria. For example...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.