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!
I attach the dummy data
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:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Convert-date-to-week-number-of-that-year/td-p/158309
