Olá comunidade!
Poderiam me ajudar com uma questão?
Tenho um arquivo que contém as datas no formato MM/dd/yyyy e preciso converter para dd/MM/yyyy
exemplo de datas que contem no arquivo:
10/6/2023
10/23/2023
10/12/2023
Checkout this expression
You need to use this expression inside for each row in datatable
DateTime.ParseExact(CurrentRow("DateColumn Name").Tostring,{"MM/d/yyyy","MM/dd/yyyy hh:mm:ss","MM/d/yyyy hh:mm:ss"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd/MM/yyyy")
Regards
Sudharsan
You need to use this expression in assign activity inside For Each Row in DataTable
CurrentRow("your date column name")=DateTime.ParseExact(CurrentRow("column name").ToString,"MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")
Hope it helps!!
Hi @amanda.gondim ,
inputDate (String) = “10/23/2023”
dateTimeValue (DateTime) = DateTime.ParseExact(inputDate, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture)
formattedDate (String) = dateTimeValue.ToString(“dd/MM/yyyy”)
or
Datetimevar= DateTime.ParseExact(“yourString”,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture). ToString(“dd/MM/yyyy”)
regards,
Read Range (Output: dt)
For Each Row (Input: dt)
Assign: row("Date") = DateTime.ParseExact(row("Date").ToString, "MM/dd/yyyy",
CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")
Write Range (Input: dt)
Hope it helps!!
DateTime.ParseExact(Date_variable.Tostring,{“MM/d/yyyy”,“MM/dd/yyyy”,“MM/dd/yyyy”},System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)
Cheers!!
Hi you can use below expression:
convertedDate = DateTime.ParseExact(originalDate, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)
data_obj = datetime.strptime(data_mm_dd_yyyy, ‘mm/dd/yyyy’)
# Formata a data para o formato desejado
data_formatada = data_obj.strftime('dd/Mm/yyyy')
Ca you try this
ConvertDate = DateTime.ParseExact(SuaData, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)
Use for each row in Data Table and within that use an assign acitivity
CurrentRow("Column Name Data To Be Stored")=DateTime.ParseExact(CurrentRow("Column Name Data To Be Taken").ToString,"MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")
Regards
