Hello all guys, pls help me convert this DateTime

_ When i get data from datatable onto browser, i have been recieved this date-time result like this “done_circle 17-Sep-2020 15:09”. But I need result like this “2020-09-17”. Pls help !!!

Hi @ANTHONY_LUAN first use regex to extract the date and use the following following link for conversion

Hope it helps you

Mark it as solution if you got it

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed:

Hi @ANTHONY_LUAN,

Try this below link:

Hope this helps.

Thanks,
Neelima.

Hi,
I would use “replace” to delete "done_cicle " and than extract the date and time with “parse”. Last step would be to return a string in the format you need. See attached xaml.
date_conversion.xaml (5,5 KB)

Hope it works for you!
Moritz

@ANTHONY_LUAN

Check as below
Convert Date & Time Format Tutorial

Hope this helps you

Thanks

Hi @ANTHONY_LUAN

Use cdate(row(“Columnname”).To string(“yyyy-MM-dd”)

Thanks
Ashwin.S

Hi @ANTHONY_LUAN,

if you’re getting that string consistently, you can split the string by blank spaces and then apply what Robot Master said “Convert.toDateTime…”

Hello Anthony,
In this video I do a lot of stuff with DateTime:

20:05 DateTime to string in multiple ways
23:00 AddDays get DayofWeek
25:40 Convert from String to DateTime
26:20 Compare DateTime

Thanks,
Cristian Negulescu