Java.text.parseexception unparseable number null

ParseException; import java. SimpleDateFormat; import java. Date; import java. Locale; import java. Level; import java. Vikram Vikram 3, 8 8 gold badges 34 34 silver badges 56 56 bronze badges.

Mohamed Mostafa Mohamed Mostafa 1. Nizzy We can use like that. Just try my code with simple java class. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does "2" become ""? I don't know. The above solution would avoid this Y problem. If you're going to allow different formats to be used to represent dates, then you're quite possibly going to have to start making use of a few regular expressions to match patterns, and a few different date formatters to then parse different inputs into dates. Hopefully, you're starting to appreciate that working with dates and the various date formats can start to get messy and complicated fast.

As such, remember that the more formats you're going to allow to be used to represent dates in your application, the more complicated it will likely get. Personally, I tend to enforce a single input date format if I'm looking for a simple implementation solution.

Consider Paul's rocket mass heater. Optional 'thank-you' note:. I am running into a problem that no matter my research I cannot figure out how to fix. I have a spreadsheet that I am reading a date from I get one each month and it all worked fine until recently Now all of a sudden I am getting a "java. ParseException: Unparseable date:" when reading the date field.

My code has not changed and I have even gone back to the previous spreadsheets and it works fine, and the SQL script to create the spreadsheet has not changed but for some reason I get that error. Ron McLeod. I like What exactly does DOBCell. Can you provide an example? Paul Clapham. The first step would be to investigate what date the parser is complaining about. I would assume that's the value of DOBCell.

Let us know if you're still confused after seeing what that is. Here is the information I get back as well as what is on the spreadsheet. Carey Brown. Saloon Keeper. In your new file is the format of the DOB column Date yyyy-mm-dd? What package are you using to read the spreadsheet?

I am using POI to read the excel database. Mike Simmons. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 0. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.