Not able to get the date in (mm/dd/yyyy) format as it shows System.Globalization.GregorianCalendar

Help
, ,
1

not able to get the date in (mm/dd/yyyy) format as it shows System.Globalization.GregorianCalendar.

2

@Karan28,

Change this mm/dd/yyyy to MM/dd/yyyy

Use the below code to convert the date format
Declare convertedDate as a datetime varible.
convertedDate = Convert.ToDateTime(“yourDateString”).Date

DateTime.ParseExact(convertedDate.ToString(“MM.dd.yyyy”), “MM.dd.yyyy”, Nothing).ToString(“MM/dd/yyyy”)

3

not working , could u please explain

4

@Karan28,

Could you please share your input datetime string sample value and the desired format to you want.

5

Hi @Karan28,

read this post:

GL with your project

6

yes ,

I an excel if If using dates like this - 05/14/2019 , means in a MM/dd/yyyy format I am getting error :-The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar.

In an input excel the dates should be in MM/dd/yyyy Format , but bot is not reading in that format
if I use dd/MM/yyyy format it works

7

@Karan28,

It is due to the system datetime format, why you need to convert it to a different format?

8

I need to get the input date from an excel in MM/dd/yyyy format and then change it to dd/MM/yyyy and use it in web automation to paste it in a ui field

9

yes i went through this post before but didn’t get the solution, Could u please help

10

Hi @Karan28

Try this one to change the date format.

DateTime.ParseExact(yourdate.toString(“MM/dd/yyyy”).ToString(),“MM/dd/yyyy”,Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Regards,
Kommi Jeevan.

11

Thankyou Buddy , Found the another solution and worked

12

what is another solution? Can you please share?