_ 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
Try this below link:
Hope this helps.
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!
Use cdate(row(“Columnname”).To string(“yyyy-MM-dd”)
if you’re getting that string consistently, you can split the string by blank spaces and then apply what Robot Master said “Convert.toDateTime…”