Dates – The Dev Mill

23 May 201915 June 2021Helpful, Troubleshooting

Changing the AM and PM designator dynamically

I received the error ‘The string was not recognized as a valid DateTime. There is an unknown word starting at index 17’ on a server when trying to convert a Date and Time string to a DateTime, but I had no such error in development or testing. The […]

8 May 201714 January 2022Helpful

Generic Date Parser in Java

I wrote this function because I was working on an application that stored a lot of dates as text, and they were a mixture of American (MM/dd/yyyy) and New Zealand formats (dd/MM/yyy). Sometimes I knew what the format was, and other times I didn’t, so the method needed […]

3 November 201612 May 2021Best Practice

Going on a Date? ISO 8601 might make good conversation

Being sick of the difference between date formats in different systems, I decided to always format my dates in YYYY-MM-DD, Nobody’s going to get that screwed up, are they? I ran a query in an enterprise system today to retrieve everything since ‘2014-11-03’, it didn’t work???It turns out […]

The Dev Mill

Finding Solutions to My Problems and Yours

Tag: Dates

Changing the AM and PM designator dynamically

Generic Date Parser in Java

Going on a Date? ISO 8601 might make good conversation