MacroScope
Programmer
I have an Access 2007, SQL Server 2012 system and I have a field that, like a birthday or anniversary, only requires day and month but not year. The data type for the table I chose is datetime, and even if I format the field Format([HOExp],"m,d') After Update, the year still returns automatically because of the data type. I thought about changing the data type to text, but that doesn't make sure someone doesn't put in an invalid entry, like 7/32, as an example.
Any suggestions on how to get the field to display only month and day will be appreciated.
Any suggestions on how to get the field to display only month and day will be appreciated.