Get datetime value from different date format from Excel

activities

#1

Hi all expert,

I have a problem to read date from Excel. I have 2 separate Excel that both have date but different date format and one (yyyy/mm/dd) can be read and possible to parse date time format but other one (dd/mm/yyyy) is not, (See also attachment as sample.)

ReadCell(日付).xaml (6.1 KB)
readCell(日付).xlsx (9.3 KB)

Does anybody know good way to convert multiple date format to uipath datetime format??
*I know one way by using separate by “/” but that somehow bothersome so I need good way to read it.

Thanks in advance,
J,


#2

@Jumbo follow this link


#3

@indra

isn’t it splitting text by slash? my point is easy way to convert formatted string to date.

and I also wanted to know why one format is okay and one is not,


#4

Hi @Jumbo

Maybe this thread will help? :slight_smile:


#5

Hi @loginerror

Thanks!! That’s what I’m looking for!