How to create a new column which has all the dates in a month?

Question

Currently I am inputting from excel 1 column which has a single date: 4/30/2021.

From this, I want to create a new column which lists out all the dates for the month of april. Ie) row 1 will be 4/1/2021 and it will go down all the way to 4/30/2021. How can I accomplish this?

For reference, please see the last column in the picture below for what I want the desired result to be.

Thank you.

valayshah · Answer

Hi @atcodedog05, thanks for the help!

So I suggested what you said and got this:

The only problem with this is that the data I'm pulling from the input file only has 1 row and therefore one date (4/30/2021). As a result, this is only giving me 4/30/2021 in the MMDDYYYY column.

Is there a way to use the 4/30/2021 I have from the input file to create 4/1/2021 to 4/30/2021? or do I have to just do that manually?

Thank you!

atcodedog05 · Answer

Hi @valayshah

Here is how you can do it. Get normal date supported in Alteryx and formatted date not Alteryx supported and will be treated a string.

Workflow:

Hope this helps : )

dates calc.yxmd

atcodedog05 · Answer

Hi @valayshah

You can use formula like

DateTimeParse(tostring(YYYY)+"-"+tostring(MM)+"-"+tostring(DD),"%y-%m-%d")

If you provide some sample data we can help you out more.

Hope this helps : )