Get Previous week Number with Tweak

[Anonymous]

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

[Anonymous]

any inputs?

[akumar2301]

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.