How to split day, month, and year in a Excel column

(0) Share

Report

Posted on by pritadewii

190

Hi.

I want to split day, month, and year in a column. So the output I get only the day, month, and year seperately. Do anybody know how to make this flow? Thank you.

The column:

Categories:

Using flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @pritadewii ,
I did a test for your reference.
In my scenario:
split(formatDateTime(item()?['Date'],'yyyy-MM-dd'),'-')[0] split(formatDateTime(item()?['Date'],'yyyy-MM-dd'),'-')[1] split(formatDateTime(item()?['Date'],'yyyy-MM-dd'),'-')[2]
item()?['Year'] item()?['Month'] item()?['Day']
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No