Help with Date Format Please

Question

First time posting - hope its in the right location.  Apologies if not.

I am looking to update the date format i am currently bringing in to "MM-DD-YYYY"

I am currently attempting to use the DATE tool but its just updating to null for the updated field.

Its currently coming in as a vstring.

Thank you for the advice help !

Date input.PNG

formula to change.PNG

caltang · Answer

I assume that your data is a string now, you can use the formula:

DateTimeParse([YourField],"%d-%b-%Y")

You can use the multi field formula tool and select the date fields you want to convert. Make sure to untick the "create new field", and tick the "change data type" to Date. Then key in the code in the expression. Easier to use [_CurrentField_] in my view once you use the multi field formula tool. Hope this helps!

Bren_Spill2 · Answer

@KellyCom - there are a couple of options in the attached file. Using a combo of DateTIme and Formula tools, or just Formula.

Thanks!

DateTime.yxmd