topic Get Previous week Number with Tweak in Talend Studio

Get Previous week Number with Tweak

Anonymous — Sat, 16 Nov 2024 03:28:33 GMT

All,

I would like to generate the weeknumber for my date column and then filter the data for previous week.

Here the tweak is if we are in Jan-1st week then it has to read previous week i.e., December month's last week data.

Thanks

Karthik M

Re: Get Previous week Number with Tweak

Anonymous — Fri, 24 Jan 2020 15:43:23 GMT

any inputs?

Re: Get Previous week Number with Tweak

akumar2301 — Sat, 25 Jan 2020 08:19:30 GMT

Did you Try

TalendDate.getPartOfDate("WEEK_OF_YEAR",Yourdate);

This will week of year , -1 will be previous week number. Then you can filter data accordingly.

To avoid change of year , use “year”along with week of year.