Splitting columns into 6 columns

Question

Hi all,

I have 3 columns(creationDate, startDate and endDate ), i want to split these columns into a day, month, year, hours, minutes, seconds. for each column.

The output is :

creationDate-daycreationDate-monthcreationDate-yearcreationDate-hourscreationDate-minutescreationDate-secondsstartDate-daystartDate-monthstartDate-yearstartDate-hoursstartDate-minutesstartDateseconds0610201916323306102019163200

How i can do it?

thanks

estherb47 · Accepted Answer

Hi @Inactive User !

You can try the DateTimeFormat function on each column. I'd use a multifield formula tool, to convert all 3 columns at once into the respective pieces

e.g., for the month, DateTimeFormat([_CurrentField_],"%m")

Each piece has a code to use for the information you want to pull out.

Let me know if that helps!

Cheers,

Esther

T_Willins · Accepted Answer

It also can be done in a Formula tool using DateTimeYear(dt), DateTimeMonth(dt), etc.

MichalM · Accepted Answer

@Inactive User

Using the Formula tool and the DateTimeFormat function is one option

You can also use the TextToColumns tool and split on colon, hyphen and a space