Date not recognized as valid format

[Chendoran_M]

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!

[Gokul001 (Gokul Balaji)]

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

[Ahmad_Rais (Ahmad)]

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

[THIRU_NANI (NaNi)]

Hey!

Try this:

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

Regards,
NaNi

[Chendoran_M]

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’."

[Ahmad_Rais (Ahmad)]

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”)

[mosa_sleeman (Mousa Suleiman)]

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

[Chendoran_M]

I have used workbook readrange

[Veera_Raj (Veeraraj Sethuraman)]

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

[mosa_sleeman (Mousa Suleiman)]

Please try with Excel within ExcelApplicationScoop

[Chendoran_M]

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’

[Ahmad_Rais (Ahmad)]

@Chendoran_M

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

first try to check this

The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar

Hi all, I’m having this error: “If: The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar” in the condition of my if statement which has this code: DateTime.ParseExact(var_currentDeadlineConsultant.ToString.Substring(0,10),“MM/dd/yyyy”,CultureInfo.InvariantCulture)<system.DateTime.Today.AddDays(25) The “var_currentDeadlineConsultant” is a generic value which derived a date from a datatable field.

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”)

[Chendoran_M]

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’."

[Gokul001 (Gokul Balaji)]

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

[Chendoran_M]

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

[Gokul001 (Gokul Balaji)]

Hi @Chendoran_M

Can you share the sample input excel file here

[Chendoran_M]

UserInputData.xlsx (9.5 KB)

[Gokul001 (Gokul Balaji)]

HI @Chendoran_M

Have a look on the XAML file

Excel Date.xaml (7.2 KB)

Regards
Gokul

[Chendoran_M]

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?

[Gokul001 (Gokul Balaji)]

Hi @Chendoran_M

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

Regards
Gokul