Change date format variable

[Maria_Ines_Almeida (Maria Inês Almeida)]

Hello,

I have a datatable where the last column has the type datetime.
The format of that date time column is MM/dd/yyyy hh:mm and I want the format dd/MM/yyyy.
What can I do to obtain the format that I want ?

Thanks

[Rahul_Unnikrishnan]

Hello @Maria_Ines_Almeida

Please refer to the below doc.

dateST is the variable with the date value.

DateTime.ParseExact(dateST.ToString(),“MM/dd/yyyy hh:mm”,Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Datetime change format

Hi, I want to get date in format like dd.MM.yyyy with input dialog. When i use default datetime variable i just can get MM.dd.yyyy That was my first question. Secondly i have to check if input format different then dd.MM.yyyy Thanks for any help.

[Maria_Ines_Almeida (Maria Inês Almeida)]

I tried the way you said but it returns an error

[Rahul_Unnikrishnan]

Can you please check the value in the CurrentRow.Item(6).ToString()

[Maria_Ines_Almeida (Maria Inês Almeida)]

yes

[Rahul_Unnikrishnan]

DateTime.ParseExact( CurrentRow.Item(6).ToString(),“MM/dd/yyyy hh:mm:ss”,Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Try this.

Also you can check the Format value activity.

[Maria_Ines_Almeida (Maria Inês Almeida)]

when i use it in a log message it works but when I assign to the item in the row it returns an exception

[Rahul_Unnikrishnan]

in the LHS, please assign a string variable instead of CurrenRow expression.