How to set Monday as the first day of week

Anonymous · ‎2019-04-12

I have a problem when I would like to get week of year by the following expression:

TalendDate.formatDate("w", date)

For example, If date = 2019-01-06 it will return 2 which I would like it to return 1.

manodwhb · ‎2019-04-12

@fararen , you have write expression the below way.

TalendDate.formatDate("w", date))-1

Anonymous · ‎2019-04-12

It's not working for the other day

manodwhb · ‎2019-04-12

@fararen ,what is other day? can you give example.

Anonymous · ‎2019-04-12

For 2019-01-07 it will return 1 which should return 2

manodwhb · ‎2019-04-12

@fararen ,check the below one is working as expected.

Sting date type

TalendDate.getPartOfDate("DAY_OF_WEEK",TalendDate.parseDate("yyyy-MM-dd", "2019-01-06"))

Date data type

TalendDate.getPartOfDate("DAY_OF_WEEK",row3.date)

Anonymous · ‎2019-04-12

I would like to get week of year not day of week

manodwhb · ‎2019-04-12

@fararen ,did you verify the below link,if not please check.

Related Topics