How can I setup the week number from my Field date. My field date starts from Last year (210102 - its format is YY/MM/DD) up to this present day. The date from last year should have at least 52 or 53 weeks and the week for this year should be auto counted so that I can compare the data from the week number on the present vs the week number last year.
I have used this script Week(Field_date) as "WEEK" but the start of date from last year which is 210102 is numbered as week 13 and the date 211113 is numbered as week 1.
