Creating a range of Dates in Date/Time formatting

[pc8807]

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!

[davegri]

My hopes would be that the field would look like this (2007-Present) or (2007-2016) to be in each cell.
I want to keep the formatting as Date/Time not short text

The data in the field isn't a date. It's a text field.
Perhaps if you explained how you want to use that field we could make suggestions...