This is likely something obvious that I am overlooking, but how do you write a formula to get a week number from a date?
Question
Week Number formula
+1+1I don’t see an easy method. You may have to get the date value of January 1st of the year of your target date, Then subtract that from your target date, then divide by 7 and round down.
+1Thank you, I decided to calculate the value in a database query and load the value as a model so I can reference it. It isn’t the most elegant solution, but it works.
+1Sorry for not getting back to you sooner. Our “FormatDate” formula function gets you started with this concept. But it doesn’t have a “Week Number” option. (We’re gonna fix that). But you can derive week number from day number divided by 7…
So a formula might look like this:
ROUND(FORMAT_DATE(“oo”, NOW())/7)
For more details about this look at our Skuid.Time documentation
Log in to Nintex Community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.