Adding information to data

[suds144]

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!

[suds144]

I attach the dummy data

[AngelosPachis]

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-ye...