Thread: Unparseable Date

Hello,

I'm new in Java and currently developing a project which requires to use dates for some of its functionality.

When trying to get the difference between the current date vs the email was sent I'm encountering the issue below.

*****:java.text.ParseException: Unparseable date: "29 May 2014 18:34:29"

Here is what my code looks like:

1. I'm getting the date of the email was sent by using mail.header. Btw I'm coding under JBPM studio.

String messageDate = (String) mail.headers["Date"];

The outpout for this looks like this: Mon, 26 May 2014 14:37:51 +0000

2. After i gather the date I parsed it to remove the day and the timezone.

String[] l_messageDate = messageDate.split(delim : ",");

String[] l_messageDatex;

if (l_messageDate.length() > 1) {
l_messageDatex = l_messageDate[1].trim().split(delim : "+");
}

String l_messageDate1 = l_messageDatex[0].trim();

Output: 29 May 2014 18:34:29

3. After parsing I'm using the following codes to minus the current date and the date of the email.

Time l_dtCurrentDate = 'now';

SimpleDateFormat format = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");

Time d1 = null;
Time d2 = null;

d1 = format.parse(l_messageDate1.trim());
d2 = format.parse((String)l_dtCurrentDate);

long diff = d2.DATE_TIME - d1.DATE_TIME;

long diff2 = d1.DATE_TIME - d2.DATE_TIME;

long diffMinutes = diff / (60 * 1000) % 60;

long diffMinutes2 = diff2 / (60 * 1000) % 60;

When the these statement run I'm encountering the said issue. I would like to request for your help in correcting my code if there are any issues.

Regards,
Kenneth

 SimpleDateFormat format = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");

here you are using MM/dd/yyyy HH:mm:ss format to parse a string to date wich is in dd MMM yyyy HH:mm:ss format.

use

 SimpleDateFormat format = new SimpleDateFormat("dd MMM yyyy HH:mm:ss");

and store it in a Date object and aftre that use your logic to find the difference d/w the parsed date object and the current date object.

Thank you all for your replies,

@aprabhat how about the format of the current date. When I extract it the output looks like this:

2014-05-30 06:39:11.482000-05:00

So basically i need to create 3 SimpleDateFormat, 1 for the email date/time, 1 for the current date and the last one is for the final format?

Please correct me if I'm wrong the SimpleDateFormat is used to change the format type of a date?

Many Thanks,

Regards,
Kenneth

@Norm thanks,

would you know what format is this in? 2014-05-30 06:39:11.482000-05:00

Many Thanks,
Kenneth

@Norms, thanks I will look it up,

Here is your SimpleDateFormat that you need "yyyy-mm-dd HH:mm:ss.SSSZ" to parse "2014-05-30 06:39:11.482000-05:00".
Hope this will solve your problem and for more detail try This

@aprabhat thanks so much...i will bookmark the link for future reference.

--- Update ---

Here is now my updated code:

// Subtract the minutes of system vs email recieved. Start
SimpleDateFormat format = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");

SimpleDateFormat format2 = new SimpleDateFormat("dd MMM yyyy HH:mm:ss");

SimpleDateFormat format3 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSSZ");

Time l_CurrDate = null;
Time l_MailDate = null;
Time d1 = null;
Time d2 = null;

l_MailDate = format2.parse(l_messageDate1.trim());
l_CurrDate = format3.parse((String)l_dtCurrentDate);

d1 = format.parse((String)l_MailDate);
d2 = format.parse((String)l_CurrDate);

long diff = d2.DATE_TIME - d1.DATE_TIME;

long diff2 = d1.DATE_TIME - d2.DATE_TIME;

long diffMinutes = diff / (60 * 1000) % 60;

long diffMinutes2 = diff2 / (60 * 1000) % 60;

I will post the result once tested..Thank you so much for your inputs.

@kennethdizon you'r welcome.

Hi All,

I was able to make the code work by simply using Interval function and didn't use d1 and d2.

SimpleDateFormat format1 = new SimpleDateFormat("dd MMM yyyy HH:mm:ss");
SimpleDateFormat format2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

Time l_MailDate = null;
Time l_CurrDate = null;

l_MailDate = format1.parse(l_messageDate1.trim());
l_CurrDate = format2.parse(l_dtCurrentDate3.trim());

Interval diff = l_CurrDate - l_MailDate;

Output: 12h55m20s

May I ask if you know how to convert this to milliseconds?

Thanks so much for your help,

Regards,
Kenneth

Don't know about any class or method to convert 12h55m20s to millisecond but you can do it easily by some string manipulation and change the seconds to millisecond as 1 second = 1000 millisecond.

Hello All,

I tried converting the message date to the same timezone of the current date inorder to get the correct time difference between the 2, however upon conversion I have encountered another error.

I created another thread for the new error titled "java.lang.IllegalArgumentException: Cannot format given Object as a Date"

Hope for your help,

Thanks so much,
Kenneth