Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Convert Month to date

Stuart_C
7 - Meteor

Hi,

 

I have a column with the full name of the month.  I created a column named "Date".  I'd like to have the the Date column show the date as the first of the month and current year.  How could I do this?

 

Current Data:

 

 
Current Data:  Output: 
MonthDate MonthDate
January  January2020-01-01
February  February2020-02-01
March  March2020-03-01
April  April2020-04-01
May  May2020-05-01
June  June2020-06-01
July  July2020-07-01
August  August2020-08-01
September  September2020-09-01
October  October2020-10-01
November  November2020-11-01
December  December2020-12-01

 

Thank you,

 

- Stuart

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

I mocked up a workflow let me know what you think?

Stuart_C
7 - Meteor

This is exactly what I wanted.  Thank you @JosephSerpis !

Labels
Top Solution Authors