Day and Month Date Time Conversion

CDF234557

How can I convert the below data to the corresponding dates ???

E.g. For April: Thursday, I want the output to be:

04/02/2020

04/09/2020

04/16/2020

04/23/2020

04/30/2020

February:WednesdayThursday

March:SundaySaturday

October:SundayThursday

April:Thursday

December:Saturday

February:MondayThursday

June:TuesdayThursday

March:SundayTuesdaySaturday

Date Time

Transformation

Preparation

Time Series

Accepted answers

CharlieS

Hi @CDF234557

I went about this by first parsing out your input into individual requests to be solved. This way, "February:WednesdayThursday" becomes "February:Wednesday" and "February:Thursday". Next I go about returning the list for each request/record.

I used a Generate Rows tool to produce the list of all days in the current year one time. Then I assigned the month and day of week titles to each date. Once this list was prepared, I joined the records that matched on month and day of week. A little formatting and output was all that was left to wrap this up.

Check out the attached workflow and let me know if that works for you.

20200211-MonthDaysOfWeekList.yxmd

All comments

MarqueeCrew

@CDF234557 ,

I've accepted your challenge and created a workflow for you. In it we assume 2020 for all dates.

You'll need to extract the package and use my new CReW macro (used to generate all days in 2020).

Cheers,

Mark

Day and Month Conversion.yxzp

CharlieS

Hi @CDF234557

Check out the attached workflow and let me know if that works for you.

20200211-MonthDaysOfWeekList.yxmd

AlteryxUserFL

Hello,

I'm not 100% sure what you are tying to do so I built a flow that will convert from days to dates and to dates to days. That should be an exact match or close to what you are trying to do.

Example.yxmd

CDF234557

This is great, thanks so much!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703