Seperate out the date and time

[Learner_SG]

Hi , my data field for date and time is in this manner : 

2022-01-04T02:26:38.2530000Z

.

How do I separte the time and date? 

[DataInsights · Accepted solution]

@Learner_SG,

Try these custom columns in Power Query:

DateTime.Date([DateTime])

DateTime.Time([DateTime])