Why Am I Always Late? Or Is It Early? Why Are Dates So Hard?

Among the challenges developers face are naming things, cache invalidation, and off-by-one errors. But the one we never talk about is date logic! Date logic is full of fallacies and challenges that we as developers often hand-wave away, only to be bitten later! In this talk, we will explore and explain some of the more common fallacies and challenges, such as daylight savings, non-standard timezones, and the ever present challenge of presenting back to the user. Along the way, we will discuss how to properly store dates and times in SQL Server, how to leverage the new types in .NET 6, and what to do with browser display. Lastly, we will talk through what to do with systems that already exist and are suffering date and time-related issues.