I am hoping someone can lend me a hand with this query. I need to query what fiscal week a given date falls in based on a fiscal calendar that starts Jan 29, 2017
Week 1 JAN 29 - FEB 04
Week 2 FEB 05 - FEB 11
Week 3 FEB 12 - FEB 18
etc...
So if the date in my table is Feb 14, the query...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.