Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

valayshah
5 - Atom

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.

 

valayshah_1-1628189781117.png

 

Thank you.

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

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 : )

atcodedog05
22 - Nova
22 - Nova

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:

atcodedog05_0-1628190194639.png

 

Hope this helps : )

 

valayshah
5 - Atom

Hi @atcodedog05, thanks for the help!

 

So I suggested what you said and got this:

 

valayshah_0-1628207043831.png

valayshah_1-1628207087516.png

 

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!

 

 

Labels
Top Solution Authors