Access 2007, SQL Server 2008 R2. ODBC connection. This is my first complex development with SQL Server. This database tracks Properties and Clients, and court dockets.
All dates in the front end are entered YYYY/DD/MM. My client is good with this and is willing to change their method of entering dates. It seems to work seamlessly with the simple date format in SQL Server.
However there are fields where only a Year is called for such as:
Tax Year = YYYY
Last Year Filed = YYYY
Year Property Purchase Date = YYYY
But I can't figure out how to handle this. Surely others have encountered this. My client is willing to go with entering like a 2014/01/01 as a generic date for these fields. But that seems clunky to me. I can't find any clear direction on this. I will take all input. However, if it involves T-SQL you'll need to be gentle with me.
Fred