topic Re: Wrong result for difference between two dates. in Talend Studio

Wrong result for difference between two dates.

Anonymous — Wed, 06 Jan 2016 21:33:15 GMT

Hi,
I have a scenario, in which I should be calculating the difference between two dates (date format MM-dd-yyyy).

I tried doing this using TalendDate.diffDate(Date1 ,Date2), but I am getting different results for different dates.
For Example: TalendDate.diffDate("12-31-2015 ,"12-01-2015") the result is 30(correct), but for TalendDate.diffDate("03-31-2015 ,"03-01-2015") the result is 29 (wrong), similarly for some other dates. The results should be long or integer.

In the job I designed, the start and end dates are calculated in the job itself based on other dates in some cases and in some cases, we extract dates from database. Both the cases the issue is same.

I tried few other solutions which were provided in the forum, but it didn't help me.

Please help me out.

Thanks,
Bharath

Re: Wrong result for difference between two dates.

Anonymous — Thu, 07 Jan 2016 08:21:29 GMT

As you're passing Strings, you're depending on default formats and may be falling foul of Java's Lenient Date Parsing.
Have you tried passing the date format as a parameter, or converting to Date type first?

Re: Wrong result for difference between two dates.

Anonymous — Thu, 07 Jan 2016 09:08:25 GMT

Hello,
I tried with TalendDate.diffDateIgnoreDST and the result seems to be ok for your examples.
DST means Daylight saving time.
If you want to know more about it, Google is your friend.
I hope it helps you.

Re: Wrong result for difference between two dates.

Anonymous — Mon, 11 Jan 2016 22:05:03 GMT

Hi Tdz,
Thanks for the help. It worked!!

Thanks,
Bharath

Re: Wrong result for difference between two dates.

Anonymous — Tue, 12 Jan 2016 08:09:24 GMT

Hello Bharath,
You're welcome.
You can mark this post as "resolved".

Re: Wrong result for difference between two dates.

Anonymous — Tue, 12 Jan 2016 08:45:40 GMT

There is an undocumented parameter to diffDate to handle this. Set ignoreDST as appropriate.

public static long diffDate(Date date1, Date date2, String dateType, boolean ignoreDST)