Pasrsing error when comparing two dates

**spacefrowns** · January 31st, 2022, 04:01 PM

Im creating a date from Calendar with format ("EEE MMM dd kk:mm:ss z yyyy"); example Mon Nov 29 10:10:50 CST 2021. Im then grabbing a date from linked string/data object in format ("MM/dd/yyyy");. In to convert it to the same format as the Calendar date for use to compare the dates. Im not sure why Im getting this errors. Any help would be greatly appreciated

                      import java.text.DateFormat;
                      import java.text.SimpleDateFormat;
                      import java.util.ArrayList;
                      import java.util.Collections;
                      import java.util.Date;
                      import java.util.Iterator;
                      import java.util.List;
		      import java.time.*;
                      import java.time.format.*;
 
                      import org.apache.log4j.Level;
                      import org.apache.log4j.Logger;
 
 
                     private Date getDateNDaysAgo(int numDays) {
                      log.debug("getDateNDaysAgo 1 " + numDays);
                      Calendar cal = Calendar.getInstance();
                      Date returnDate = null;
                      cal.add(Calendar.DATE, -(numDays));
                      returnDate = cal.getTime();
                      log.debug("getDateNDaysAgo 2" + returnDate);
                      return (returnDate);
		   }	
 
                      if(getDateNDaysAgo != null) {	
                        System.out.println("getDateNDaysAgo 2" + getDateNDaysAgo);					  
 
                    } 
 
                      Date thresholdDate = null;
		      boolean isAccountCreatedOver25Days = false; 
                      String EffectiveHireDateString = link.getAttribute("EffectiveHireDate");  // MM/dd/yyyy
 
				  if(Util.isNotNullOrEmpty(EffectiveHireDateString)) {
 
                  DateTimeFormatter mdy = DateTimeFormatter.ofPattern("MM/dd/yyyy");
                  DateTimeFormatter formatter = DateTimeFormatter.ofPattern("EEE MMM dd kk:mm:ss z yyyy");
 
 
                  try {
 
		   LocalDate EffectiveHireDate = mdy.parse(EffectiveHireDateString, LocalDate::from);
                    LocalDateTime ldt = LocalDateTime.of(EffectiveHireDate, LocalTime.of(0, 0));
                    ZonedDateTime zdt = ZonedDateTime.of(ldt, ZoneId.systemDefault);
 
		   String formatted = formatter.format(zdt);
                    ZonedDateTime parsedEffectiveHire = formatter.parse(formatted, ZonedDateTime::from);
                    log.debug("parsedEffectiveHire" + parsedEffectiveHire);
 
                    thresholdDate = getDateNDaysAgo(25);
                    log.debug("thresholdDate" + thresholdDate);
 
                   if(parsedEffectiveHire != null) {	
                        System.out.println("parsedEffectiveHire" + parsedEffectiveHire);					  
					  }
 
 
                  if(parsedEffectiveHire.compareTo(thresholdDate) &lt; 0){
                  log.debug("parsedEffectiveHire 2" + parsedEffectiveHire);
 
                  isAccountCreatedOver25Days = true; 
                  }
                  }
                      catch (ParseException e) {
                      log.error("Error attempting to parse EffectiveHireDate Date");
                      }
                      }
                      }

**Norm** · January 31st, 2022, 04:10 PM

why Im getting this errors

Please copy the full text of the error messages and paste it here.

Please edit your post and wrap your code with code tags:

[code]
**YOUR CODE GOES HERE**
[/code]

to get highlighting and preserve formatting.

Make sure the posted code can be compiled and executed for testing. I do not see a declaration for the class or a main method for execution.
http://sscce.org/

**spacefrowns** · January 31st, 2022, 04:27 PM

Its beanshell with code passing in in xml object.

Exception: sailpoint.tools.GeneralException: BeanShell script error: bsh.ParseException: Parse error at line 93, column 65. Encountered: ( BSF info: script at line: 0 column: columnNo
sailpoint.tools.GeneralException: sailpoint.tools.GeneralException: BeanShell script error: bsh.ParseException: Parse error at line 93, column 65.

which is this block

try {

LocalDate acuEffectiveHireDate = mdy.parse(acuEffectiveHireDateString, LocalDate::from);
LocalDateTime ldt = LocalDateTime.of(acuEffectiveHireDate, LocalTime.of(0, 0));
ZonedDateTime zdt = ZonedDateTime.of(ldt, ZoneId.systemDefault);

String formatted = formatter.format(zdt);
ZonedDateTime parsedAcuEffectiveHire = formatter.parse(formatted, ZonedDateTime::from);
log.debug("parsedAcuEffectiveHire" + parsedAcuEffectiveHire);

thresholdDate = getDateNDaysAgo(25);
log.debug("thresholdDate" + thresholdDate);

if(parsedAcuEffectiveHire != null) {
System.out.println("parsedAcuEffectiveHire" + parsedAcuEffectiveHire);
}

**Norm** · January 31st, 2022, 04:38 PM

Sorry, I do not know anything about beanshell.
If you have a java programming problem please make a SSCCE and paste it here.

Please edit your post and wrap your code with code tags:

[code]
**YOUR CODE GOES HERE**
[/code]

to get highlighting and preserve formatting.

**spacefrowns** · January 31st, 2022, 05:15 PM

Basically. Im trying to get a string date format MM/dd/yyyy converted to Date with format EEE MMM dd kk:mm:ss z yyyy for use to compare to another date format EEE MMM dd kk:mm:ss z yyyy. Failing miserable it seems.

**Norm** · January 31st, 2022, 05:44 PM

Failing miserable it seems.

Make a sscce that demonstrates the problem and paste it here.

**LeslieS** · February 1st, 2022, 10:49 PM

I couldn't get it to recognize ZoneId without the specific import:
import java.time.ZoneId;

Next in the try block you are using systemDefault but that is a method and needs the ()

ZonedDateTime zdt = ZonedDateTime.of(ldt, ZoneId.systemDefault());

A little further down I ran into another problem.
First I needed the calendar import:
import java.util.Calendar;

After that the compareTo line is fouled. You cannot compare Date with ZonedDateTime.
(I also have no idea how to implement the &lt generics comparison thing so I skipped that until I can learn more about it)
I ran into bracket nightmare so I split it into two lines:

        ZonedDateTime z = ZonedDateTime.ofInstant(thresholdDate.toInstant(), ZoneId.systemDefault());
        if(parsedEffectiveHire.compareTo(z) < 0){

The following is the entire code I ran using the online compiler found here
Please excuse the default class name HelloWorld and the fact that I changed some of the variable names you used.

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.time.*;
import java.time.format.*;
import java.time.ZoneId; 
import java.util.Calendar; 
 
public class HelloWorld{
 
     public static void main(String []args){
        //System.out.println("Hello World");
        String stringDate = "01/12/21";
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("EEE MMM dd kk:mm:ss z yyyy");
        DateTimeFormatter mdy = DateTimeFormatter.ofPattern("MM/dd/yy");
        Date date = new Date("SAT DEC 28 01:12:32 PST 1996");
        //Date newDate = mdy.parse()
        LocalDate d = mdy.parse(stringDate, LocalDate::from);  
        LocalDateTime ldt = LocalDateTime.of(d, LocalTime.of(0, 0));
        ZonedDateTime zdt = ZonedDateTime.of(ldt, ZoneId.systemDefault());
        System.out.println(d);
        System.out.println(ldt);
        System.out.println(zdt);
 
        String formatted = formatter.format(zdt);
        ZonedDateTime parsedEffectiveHire = formatter.parse(formatted, ZonedDateTime::from);
        System.out.println("parsedEffectiveHire " + parsedEffectiveHire);
 
        Date thresholdDate = getDateNDaysAgo(25);         
        System.out.println("threshold date " + thresholdDate);
        ZonedDateTime z = ZonedDateTime.ofInstant(thresholdDate.toInstant(), ZoneId.systemDefault());
        if(parsedEffectiveHire.compareTo(z) < 0){
            System.out.println("older than 25 days");
        }
     }
     private static Date getDateNDaysAgo(int numDays) {
                      //log.debug("getDateNDaysAgo 1 " + numDays);
                      Calendar cal = Calendar.getInstance();
                      Date returnDate = null;
                      cal.add(Calendar.DATE, -(numDays));
                      returnDate = cal.getTime();
                      //log.debug("getDateNDaysAgo 2" + returnDate);
                      return (returnDate);
		   }	
}

It really is better to cut out enough code for the forum viewer to simply cut and paste and run.
This gives you far quicker and better results.

**Norm** · February 2nd, 2022, 12:57 PM

Is this the same problem: https://coderanch.com/t/749395/java/...ifference-days

**LeslieS** · February 2nd, 2022, 06:58 PM

Originally Posted by Norm

Is this the same problem: https://coderanch.com/t/749395/java/...ifference-days

Looks like it. Its a shame he might miss the answer here, but over there they seem to know a lot more than I do about the various date types in java.

**patricajohnson51** · April 22nd, 2024, 05:32 AM

It seems you're encountering a parsing error when comparing two dates in your Java code. The issue may lie in how you're parsing and comparing the dates. Let's break down the potential solutions:

1. Parsing Error:
- Ensure that the date formats used for parsing (`"MM/dd/yyyy"` and `"EEE MMM dd kk:mm:ss z yyyy"`) match the actual formats of the dates you're trying to parse. Any discrepancy will lead to parsing errors.
- In your code, you're using `DateTimeFormatter` for parsing the date string into a `LocalDate` and then formatting it into a string again. This step might not be necessary if your goal is just to compare the dates. Instead, directly parse the date string into a `ZonedDateTime`.

2. Comparison Error:
- When comparing dates, make sure both dates are of the same type. In your case, both `parsedEffectiveHire` and `thresholdDate` should be of type `ZonedDateTime` since you're dealing with time zones.
- Check if `parsedEffectiveHire` and `thresholdDate` are not null before attempting the comparison to avoid `NullPointerException`.
- Use `compareTo` method correctly for date comparison. Ensure you're using `compareTo` method properly according to your comparison logic.

3. Debugging:
- Add debug statements to print out the parsed dates (`parsedEffectiveHire` and `thresholdDate`) just before the comparison to ensure they are parsed correctly and have expected values.
- Check the log messages for any additional information or errors that might help pinpoint the issue.

Here's a revised version of the comparison part of your code:

```java
if (parsedEffectiveHire != null && thresholdDate != null) {
System.out.println("parsedEffectiveHire: " + parsedEffectiveHire);
System.out.println("thresholdDate: " + thresholdDate);

if (parsedEffectiveHire.compareTo(thresholdDate) < 0) {
log.debug("parsedEffectiveHire is before thresholdDate");
isAccountCreatedOver25Days = true;
} else {
log.debug("parsedEffectiveHire is after or equal to thresholdDate");
}
}
```

Make sure to adjust the comparison logic (`< 0`, `== 0`, or `> 0`) according to your specific requirements. Also, ensure that the date formats and types are consistent throughout the code. If you encounter any errors or unexpected behavior, review the debug output and log messages for further insights.

In case you need further assistance with your Java assignment and resolving the date parsing error, there are resources available online that provide programming homework help like ProgrammingHomeworkHelp.com. You might find useful insights on platforms that offer educational support for Java programming tasks.

Thread: Pasrsing error when comparing two dates

LinkBack

Thread Tools

Display

Pasrsing error when comparing two dates

Re: Pasrsing error when comparing two dates

Re: Pasrsing error when comparing two dates

Re: Pasrsing error when comparing two dates

Re: Pasrsing error when comparing two dates

Re: Pasrsing error when comparing two dates

Re: Pasrsing error when comparing two dates

Re: Pasrsing error when comparing two dates

Re: Pasrsing error when comparing two dates

Re: Pasrsing error when comparing two dates

Similar Threads

comparison between 3 dates :

problem Comparing date and month from dates

Comparing Two Dates

error when comparing 2 string objects

UTC Dates

Tags for this Thread