I have a field called FieldA which has a date value. I would like to group the dates by week. Week1 - Week52.
What syntax can I use to assign a week number to each respective date.
We will use Sunday as the first day of the week and Saturday as the last day of the week.