I have a query where i am using Builder to identify the Week Number for specific dates. In Excel i use the WEEKNUM Function, but I cannot find this in Access.
Is there a way to make this function available in Access?
Thank you
I have a query where i am using Builder to identify the Week Number for specific dates. In Excel i use the WEEKNUM Function, but I cannot find this in Access.
Is there a way to make this function available in Access?
Thank you
Try
https://access-programmers.co.uk/for...d.php?t=216309Code:DatePart("ww", [YourDateField])
What kind of week number? US? ISO? Some other (there are lot of different variants for week numbering over the world)?
I don't know which format my version of Excel uses, I think it is 'US' format.
Thank you very much, this worked
you might find this site useful going forward
https://www.techonthenet.com/access/functions/
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.