Hello, Everyone!
This is my first question. I'm currently working on a database and I want to include a Field for years active. I'm having trouble creating a yyyy format that would allow for both ranges.
My hopes would be that the field would look like this (2007-Present) or (2007-2016) to be in each cell. The problem is that whenever I try to create a format that does that the dates i enter create an error. I want to keep the formatting as Date/Time not short text
The current input mask that I am using is "("0000\-0000")";0;_
I'm new to access and searched all over google and the access help function to no avail.
Anything that could point me in the right direction or any help would be greatly appreciated!
Thank you!