AnsweredAssumed Answered

How to get a calendar week?

Question asked by Julian Menningen on Aug 4, 2015
Latest reply on Dec 1, 2015 by Julian Menningen
Hi Guys,

I guess a rather easy one, but didn't find a solution yet:

How do I get a calandar week of a specific date?

I tried to:
1. subtract two dates ("the date i'm looking at" MINUS "the first day of the year")
2. divide by 7.
3. Round down

But that seems a little unstable, since I cannot be 100% sure that I always have to round down, can I?

Best
Julian

Outcomes