@TerribleMaps working in various it contexts and integrations I tend to mostly Format to YYYYMMDD because it is even an integer, that can be compared with < and >

@felix
And it aligns well when adding hours, minutes and seconds. yyyy-mm-dd hh:mm:ss is ordered the same way as other numbers.

At least the Americans aren't trying to make mm:ss:hh a thing.
@TerribleMaps

@felix Or you can just use the built-in date type of your favorite language and still compare them with > or whatever you like. :cirno_shrug:

@TerribleMaps