Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Formula to arrive at date when I have Day, Month and Year in separate columns

5 - Atom

Can someone please help me to arrive at the date, when I have the day, month and year in three different columns.


Any help will be appreciated.


DayMonthYear Desired Output
10122009 10-12-2009
862018 08-06-2018
1912000 19-01-2000
16 - Nebula
16 - Nebula

The formula would be [Day]+'-'+[Month]+'-'+[Year] for your new field, but please note that the Alteryx standard date format is yyyy-mm-dd.

14 - Magnetar
14 - Magnetar

Hi @Upansu!


@DavidP is correct in that you can just append the fields together using the plus sign and quotes. Here are a couple additional specifications if you need them:


  • The fields must already be strings coming into the Formula tool OR you can use the tostring() function each time you reference one of the field names if they're numeric.


  • If you need the leading zero's and the day or month number is only one digit, you could adjust the formula to look like this:

This should still be output as a new string field.



  • If you want your new field to be a date type, adjust the formula to look like this:

This will allow Alteryx to recognize your new field as an actual date field if you need to perform any calculations on it or anything downstream and will output the field in Alteryx's yyyy-mm=dd format.