topic Re: Date Subtraction for Month Start Dates in Talend Studio

Date Subtraction for Month Start Dates

rajesh90 — Fri, 26 Feb 2021 16:12:56 GMT

Hello Everyone,

In my code, whenever I pick source files I need to pick T-1 date files. So when I subtract the month starting date with -1 using the below expression it results to incorrect date value,

Expression :

context.Load_Date=String.valueOf(Integer.parseInt(TalendDate.getDate("YYYYMMDD"))-1);

Example :

Input Date = 20210101

Output Date Value received after subtracting 1 = 20210200

The format of the date is YYYYMMDD.

Can you help with a solution to fix this issue.

Thank you.

Re: Date Subtraction for Month Start Dates

prg — Fri, 26 Feb 2021 16:44:50 GMT

Hello @Rajesh L R ,

Could you please confirm if you mean "T-1" as the previous day?

Please provide us the expected output, so that we can check accordingly.

Regards,

Vaishnavi

Re: Date Subtraction for Month Start Dates

rajesh90 — Fri, 26 Feb 2021 18:02:17 GMT

Hi @Vaishnavi Khandelwal ,

Yes T-1 is previous day.

Expression :

context.Load_Date=String.valueOf(Integer.parseInt(TalendDate.getDate("YYYYMMDD"))-1);

Current Data :

Input Date : 20210301

Output Date : 20210300

Expected Data :

Input Date : 20210301

Output Date : 20210228

Re: Date Subtraction for Month Start Dates

prg — Mon, 01 Mar 2021 17:21:33 GMT

Hello @Rajesh L R ,

Please try using the below logic;

Date a=TalendDate.addDate(TalendDate.getCurrentDate(),-1,"dd");

System.out.println(TalendDate.formatDate("yyyyMMdd", a));

Please let us know if it helps. If yes, mark it resolved (Kudos also accepted).

Regards,

Vaishnavi

Re: Date Subtraction for Month Start Dates

rajesh90 — Fri, 05 Mar 2021 02:58:40 GMT

It worked, thank you @Vaishnavi Khandelwal