Hi All,
A quick question. I have the following input:
And want the following output (so to have a formula that translates the "start date" into the week:
Thank you!
Hi @suds144 ,
Have a look at the following page https://help.alteryx.com/20214/designer/datetime-functions
I think what you're looking for is a Datetimeformat function : Datetimeformat([Date_Field],"%W")
with %W giving you the week number assuming the first date being Monday.
Another very helpful post can be found below, in case you're after the ISO-week number: