On my access application, I am writing an Event procedure in VBA to get no. of working days. But i have found some type mismatch error when i use year(now()) or month(now()). With this i have noticed that Year() , month() and Day() function is not working only for that editor. what could be wrong here?
I am expecting an early response.