Excel "isoweeknum" equivalent function in Access

[okl]

Hi there,

In excel i use isoweeknum for week number.
In Access what is the equivalent function for it to convert a date dd/mm/yyyy into ISO week num?

Thanks

 

[Joe4]

It looks like you can create your own User Function to do it in Access.
See: https://stackoverflow.com/questions/34742007/ms-access-get-iso-standard-week-number

 

[xenou]

Another solution would be to use a lookup table to map dates to week numbers and use that lookup table in your queries, forms and reports.