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

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,

Date Time

Best Practices

Accepted answers

Here is how you can do it.

Workflow:

Hope this helps : )

All comments

Here is how you can do it.

Workflow:

Hope this helps : )

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703