Assign: Conversion from string "31-03-2022" to type 'Date' is not valid I Need Output as 31-MAR-2022

Gopikrishna_S · August 30, 2022, 11:41am

suggest a method to resolve this issue

ppr · August 30, 2022, 11:44am

DateTime.ParseExact(YourStringVar, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).toString("dd-MMM-yyyy")

Gopikrishna_S · August 30, 2022, 11:45am

Please do Share the expression and also mention the data type of assigning variable

ppr · August 30, 2022, 11:47am

Usage of the toString method let us derive the resulting datatype: String

Gopikrishna_S · August 30, 2022, 11:59am

Getting It Correctly, Thanks ppr, and also how to Convert 20-05-2022 to 20-MAY-2022
suggest a expression

ppr · August 30, 2022, 12:00pm

will be the same approach

prototype it at your end

Gopikrishna_S · August 30, 2022, 12:12pm

Screenshot 2022-08-30 173923
Meanwhile getting Output I am getting Like this excel…04-07-2022 but actually I need 04-JUL-2022 like this

system · September 2, 2022, 12:13pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
ERROR: Assign: Conversion from string "16/03/2020" to type 'Date' is not valid Learn studio , error	6	7305	January 22, 2021
Assign: Conversion from string "29-04-2022" to type 'Date' is not valid Forum excel , activities , studio , question	6	1293	July 21, 2022
Assign - String was not recognized as a valid DateTime Activities excel , activities , studio , question	8	2363	June 27, 2022
UiPath Date Formatting From Excel StudioX	2	1353	May 28, 2020
UiPath - Error Assign: String was not recognized as a valid DateTime. Date format is dd-MM-yyyy HH:mm Something Else	7	193	December 17, 2023