DataType Year? Just Year

[ElcoyotldeAztlan]

Hello
I was wondering if anyone has found a way to set a DataType just as a Year but also include AD and BC.
I know there is Date/Time and those formats are not what I'm looking for.
Any thoughts or ways around this?
is this a limitation?

Sure i can have a Text field and type all my years but if there is a shortcut that could be nice

Thanks

 

[CJ_London]

you can set a field as a number then use the format property to show AD if positive and BC if negative - put this in the format property

###0"AD";###0"BC"

will display 1966 as 1966AD
and -300 as 300BC

 

[MarkK]

I would just store the year as an integer with positive numbers indicating AD and negative numbers indicating BC. I don't see a limitation. There is no specific datatype for inches, or kilometers. And if you need to display the "AD" or "BC" you can write a function, or do something like this in a query...

SELECT MyYear & IIF(MyYear < 0, " BC", " AD") As MyFormattedYear 
FROM MyTable

Makes sense?
Mark

 

[MarkK]

Excellent suggestion by CJ, where he sets the Format property of a textbox control.