Hi all
Need your expertise. I am trying to fetch date from data table cell which is in “22-Dec-2022” format. I would need to convert this format as ‘12222022’.
Tried to convert the format by using “date.ParseExact(dtQuoteData.Rows.Item(22)(12).ToString, “DDMonYYYY”, system.Globalization.CultureInfo.InvariantCulture).ToString(“MMDDYY”)” but getting exception “Assign: String ‘22-Dec-2022’ was not recognized as a valid DateTime.”
Can someone please help me resolve this error? Thanks!
Hi @Naresh_Upadhyay1
Welcome to UiPath community
Datetime.ParseExact(dtQuoteData.Rows.Item(22)(12).ToString, “dd-MMM-yyyy”, system.Globalization.CultureInfo.InvariantCulture).ToString(“MMddyyyy”)”
The expression you used is correct…but the formats are as follows
Input: dd-MMM-yyyy
Output - MMddyyyy
And also verify if you have time also in the variable…generally in excel you might not see but time might be there…if so use hh:mm:ss
Cheers
Welcome to UiPath Forum
What about this
Input
Output
Code
CDate(dt.Rows.Item(0)(0)).ToString("MMddyyyy")
Workflow
Thanks,
