Date extraction

Question

I am trying to extract the Month and Year from the dates in the following formats. Con some please suggest

Date Year Month 2021-06-04202162021-06-172021602.06.20212021615.06.2021202162021-06-16202162021-06-21202162021-06-23202162021-06-2520216

atcodedog05 · Accepted Answer

Hi @Abhii2658

Here is how you can do it using regx.

Workflow:

Hope this helps : )

RolandSchubert · Accepted Answer

Hi @Abhii2658 ,

the DateTime functions will help you solve this problem.

First step is to convert the [Date] column to a Date data type. As there are two different date formats (YYYY-MM-DD and DD.MM.YYYY) you should use a Formula tool with a condition to apply the "right" DateTimeParse function:

A new field [Date_Converted] with data type "Date" is created.

Second step could be to extract year and month using the functions DateTimeYear and DateTimeMonth from this column.

I've attached a sample workflow, hope this is helpful.

Let me know if it works for you.

Best,

Roland

binay2448 · Accepted Answer

Attached my solution....