How to create a Date field using existing year and month fields

[JonaV]

Hi,

I am having issues coming up with a solution to how to create a date column.

I currently have two fields on that has the month number and one that has the year number. Ex. 11 and 2018 as seen in the image below.

I'd like to use the event year and month # columns to come up with this new date field

Thank you,

[atcodedog05]

Hi @JonaV 

Here is how you can do it.

Workflow:

Hope this helps : )

[JonaV]

This is great!

I used this formula but I had to output it as a V_String because it would return nulls if I had it as a date data type in the formula tool, so I used the DateTime tool to output it as a date data type.

But, how can I have it output it in this format "mm/dd/yyyy"?

I changed the formula to make it look in this format, but after using the datetime tool it still outputs it in the "yyyy-mm-dd" format

[atcodedog05 · Accepted solution]

Hi @JonaV 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @JonaV 

Cheers and have a nice day!