Getting A Date Is Hard

Nate Johnson has a fun rant about datetime ranges in SQL Server and date pickers:

I mean, I’m not that old, but spinning thru a few decades is still slower than just typing 4 digits on my keyboard — especially if your input-box is smart enough to flip my keyboard into “numeric only” mode.

Another seemingly popular date-picker UX is the “calendar control”.  Oh gawd.  It’s horrible!  Clicking thru pages and pages of months to find and click (tap?) on an itty bitty day box, only to realize “Oh crap, that was the wrong year… ok let me go back.. click, click, tap..” ad-nauseum.

Food for thought.

Related Posts

JSON Dates In SQL Server

Bert Wagner explains how to handle JSON datetime strings in SQL Server: In SQL Server, datetime2’s format is defined as follows: YYYY-MM-DD hh:mm:ss[.fractional seconds] JSON date time strings are defined like: YYYY-MM-DDTHH:mm:ss.sssZ Honestly, they look pretty similar. However, there are few key differences: JSON separates the date and time portion of the string with the […]

Read More

That 53rd Week

Jens Vestergaard notes that you can sometimes have a 53rd week in the year: There are a lot of great examples out there on how to build your own custom Time Intelligence into Analysis Services (MD). Just have a look at this, this, this, this and this. All good sources for solid Time Intelligence in […]

Read More

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories

May 2017
MTWTFSS
« Apr  
1234567
891011121314
15161718192021
22232425262728
293031