Text to Date/Time and Getting Each Saturday of the Month

[saltyplanet]

Hi Alteryx Community,

I received this data consisting of the monthly amount for wages and the month indicator in the text format. I would like to distribute the monthly total by the number of weekending dates for each month.

For example, there are 4 weekending dates (Saturdays) in January 2020. I would like to get 2314.24 / 4 = 578.56 for each weekending date in January 2020. Please see the screenshot. 

I have also attached the alteryx file. Thank you so much in advance!!!

[atcodedog05 · Accepted solution]

Hi @saltyplanet 

Here is how you can do it.

Workflow:

Hope this helps : )

[saltyplanet]

hi @atcodedog05

thank you for your quick response! Would you mind showing me how we can transform Jan-20 to 01/01/2020?

Thank you

[gabrielvilella]

You can use this formula DateTimeFormat(DateTimeParse([Field1],'%b-%y'),'%d/%m/%Y')

[atcodedog05]

Happy to help : ) @saltyplanet 

Cheers and have a nice day!