How to copy data from one column to another existing column

[JeffJones]

I have a column named Date with a list of various dates.  I would like to copy these dates over to  an existing column named MonthYear which all the values are currently null.   Any assistance would be much appreciated!

[flying008]

Hi , @JeffJones 

Maybe you can add a formula tool in your workflow, then select the field [MonthYear], and type formula: = [Date]

[binuacs]

@JeffJones There are multiple ways you can do this. Attaching a sample workflow for your reference

[SmitaLohande]

Hi,

I have attached the solution. Month year column is string and Date is date datatype.

In Date Time parse tool, convert the date to string for the 'Date' column, and in formula tool, replace the 'month year' column with the 'date' column (See 2nd screen shot). Finally then you can convert back the 'month year' column to a 'date' datatype.

Please mark it as a solution if it helped you :)