Greetings,
Hope all is going well
Reference made to week of event
We want to retrieve enrollments from a specific week.
so we decided to create a data element “Week of event”
and I used the function weeks between
but weeks between (<enrollment date, and 2020-01-01)
this shall give the week of the year
this didnt work, and this will cause a problem when the year changes to the 2021.
so is there any function that i can use to have the week number in the data element no matter what year is it.
sincerely,
HS.