Thanks very much to all for your suggestions. I am indeed using a Date/Time field but don't know how I should change the Format property of the form control. I tried raskews suggestion which was great but this returned US format so instead of getting 3/01 I got 1/01 (with the month number...
I have a date field in a form that is designed to return last month's date in m/yy format eg in April 2001 it should automatically come up with 3/01. The expression used for this field was DateAdd("m",-1,Date()). This worked well until February 2001 and up till then only returned a...
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.