Hard coded dates were rampant here.
I 'used to be' a systems analyst at a major pharmaceutical company where there were clear divisions of labor, a set development, test and production environments and rigorous testing and QA requirements, including documentation. I left my SQL/DB2 skills behind over 20 years ago when our eldest was born. I was asked to 'help out' here since I 'knew' SQL and the remote/rural area we now live in has few technical folks. I am painfully aware of my limitations and am studying almost every night and applying what I have learned at every opportunity. The biggest stumbling block has been a complete absence of any documentation at all and hard-coded dates in virtually all view defs. Yes, this past December/January was quite busy!
But, even after such a hiatus, I can still remember what NOT to do - like hard code dates!
Unfortunately, no one else here knows SQL, or any programming tools. So I have no one to learn from or collaborate with. On the plus side, I can set my own (part-time) schedule, I have rediscovered how much I enjoy this and I am considering working towards certification. Just in time for the empty-nest as our youngest will be off at college in 18 months!