DEV Community

loading...

Discussion on: Response to isDate() Blog Post

Collapse
gamesover profile image
James Moberg Author

We may need to deal with this before 12/31/9999. The current max date for MSSQL SqlDateTime while java is 12/31/999999999. Luckily none of my clients are asking to schedule anything that far out in advance "yet".

What would it take to get all related technologies to agree on a standard? (ie, the current max date for java is 12/31/999999999.)

A recent project had a high lifetime membership calculation bug. Instead of entering "birthdate", the customer entered "current age". Server-side isDate() returned "yes" that the integer was a valid date, but couldn't perform a DateDiff() using the "valid date". To fix, I added a check using isValid("usdate", birthdate).