Date not recognized as valid format

Learning & Development Programs Automation Starter
1

Screenshot (84)
Screenshot (84)1920×1080 269 KB

I am getting this error while trying to get a date from excel. In excel it’s in ‘dd/MM/yyyy’ format but while executing, I get this error with excel data in ‘MM/dd/yyyy hh:mm:ss’ format. Kindly help me out here!

2

Hi @Chendoran_M

How about this expression?

DateTime.ParseExact("Input string","dd/MM/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy")

Regards
Gokul

3

HI seems like it didnt get recognized as date because the for mat is ‘mm/dd/yyyy hh:mm:ss’

Datetime.ParseExact(row(“yourcolumnname”).ToString.SubString(0,10),“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MMM-yyyy”)

or

Datetime.ParseExact(row(“yourcolumnname”).ToString.SubString(0,10),“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MMM-yyyy”)

this will cut the hh:mm:ss

try to adjust it

Regards
ahmad

4

Hey!

Try this:

Datetime.ParseExact(Strinput.ToString, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Regards,
NaNi

5

I have tried substring and the hh:mm:ss format is removed now but I’m getting the below error.

"Source: Assign

Message: The DateTime represented by the string ‘08/15/2022’ is not supported in calendar ‘System.Globalization.GregorianCalendar’."

6

can i see your assign script?

try
Datetime.ParseExact(row(“yourcolumnname”).ToString.SubString(0,10),“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)

7

@Chendoran_M
Please try to read the excel via Excel application scoop and try to parse the date.

8

I have used workbook readrange

9

row(“columnname”).tostring.split(" "c).toarray(0).tostring

10

Please try with Excel within ExcelApplicationScoop

11

Datetime.ParseExact(CurrentRow(“DATE OF DEPARTURE”).ToString.SubString(0,10),“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

I’ve tried this and still getting this error:

"22.4.3+Branch.master.Sha.926b4e643842c0bd04601053628fabcad850b6c3

Source: Assign

Message: The DateTime represented by the string ‘15/08/2022’ is not supported in calendar ‘System.Globalization.GregorianCalendar’."

I don’t understand why am I getting this when the date format is changed to ‘dd/MM/yyyy’

12

first try to check this

seems like you can set the correct value from excel app (dd/MM/yyyy) and then

try

Datetime.ParseExact(CurrentRow(“DATE OF DEPARTURE”).ToString.SubString(0,10),“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

13

Tried it… still the same;

Message: The DateTime represented by the string ‘08/15/2022’ is not supported in calendar ‘System.Globalization.GregorianCalendar’.

This is what happens to me as well…
My excel format was dd/MM/yyyy but in the background it switched to MM/dd/yyyy while writing a line in uipath

when I tried this;
Datetime.ParseExact(CurrentRow(“DATE OF DEPARTURE”).ToString.SubString(0,10),“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

the date format got converted from “MM/dd/yyyy” to “dd/MM/yyyy” but I get an error while executing, stating that
The DateTime represented by the string ‘15/08/2022’ is not supported in calendar ‘System.Globalization.GregorianCalendar’."

14

Hi @Chendoran_M

Try this

DateTime.ParseExact(row("Columnname").tostring,"dd/MM/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Can you tell me the input date format and output data format

Regards
Gokul

15

Input date format: MM/dd/yyyy
Output date format: dd/MM/yyyy

I am reading the input value from the excel, where the date is in dd/MM/yyyy format but while checking it in uipath, the date format is read from excel as MM/dd/yyyy

16

Hi @Chendoran_M

Can you share the sample input excel file here

17

UserInputData.xlsx (9.5 KB)

18

HI @Chendoran_M

Have a look on the XAML file

Excel Date.xaml (7.2 KB)

Regards
Gokul

2 Likes
19

Thank you @Gokul001.

I am passing this ‘str_User_DepDate’(which holds the date read from excel) variable to another workflow, where the argument’s data type is ‘DateandTime’
and I have converted the string to date and time by using this ‘Convert.ToDateTime(str_User_DepDate)’ but I am getting this error stating;
“Invoke WebDataExtraction workflow: String ‘15/09/2022’ was not recognized as a valid DateTime.” Any idea on how to solve this?

20

Hi @Chendoran_M

Can you please create a new topic to discuss this aspect.

Regards
Gokul