Convert date of string format to date time

Help
1

hiii guys,i have a query,say i have a string like strdate=“01/20/2019” and i just tried it to convert it into date time format like **Convert.todatetime(strdate)**as expected it got converted into datetime format but when the strdate=“20/01/2019” it is saying string was not recognized as valid date time. now my question is it convert into datetime format only when the **strdate=“01/20/2019”**or if it possible if it is in **str=“20/01/2019”**format plz help me out from this.thankyou

1 Like
2

Hi @venkatmalla6

Use cdate (strdate).Tostring (“MM/dd/yyyy”)

Thanks
Ashwin.S

1 Like
3

Hi buddy @venkatmalla6
If the format is “01/20/2019”
Then use this
In_string = “01/20/2019”
Out_datetime = Datetime.ParseExact(In_string.ToString,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture)

Or if it is in this format
In_string = “20/01/2019”
Out_datetime = Datetime.ParseExact(In_string.ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)

This will work for sure buddy
Cheers @venkatmalla6

2 Likes
4

@Palaniyappan hiii i tried second one it is giving me the output as 01/20.2019.

5

Can i have a view on screenshot of that buddy
Cheers @venkatmalla6

6

@Palaniyappan sure buddy,

Capture14
Capture141366×768 115 KB
Capture15
Capture151366×768 126 KB

7

I think it works fine buddy, we are able to convert right
Any issue
Cheers @venkatmalla6

8

@Palaniyappan yeah buddy it works but the thing is the format of date has changed.actually i gave my string as 20/01/2019.the output which i want is 20/01/2019 in datetime format but it is giving me as 01/20/2019.

And one more doubt if i have a string like this 20JUNE2019.can we make it as 20/06/2019 in dateformat.

9

In that case we can mention the format we want in ToString ()
Like this
In_string = “20/01/2019”
Out_datetime = Datetime.ParseExact(In_string.ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture). ToString (“dd/MM/yyyy”)

Yes of course for this
Out_datetime = Datetime.ParseExact(In_string.ToString,“ddMMMMyyyy”,System.Globalization.CultureInfo.InvariantCulture). ToString (“dd/MM/yyyy”)

10

Well for this once when a string is converted to Datetime we dont need to worry on the format, dot net will take that as Datetime in general and compare with any Datetime value
Only when we enter the Datetime as string to a field we need to work on format needed
. cheers @venkatmalla6

11

@Palaniyappan ok thanks buddy.

12

Any issues Still
Did thia get resolved
Cheeers @venkatmalla6

13

@Palaniyappan yeah buddy and one more thing yesterday i asked a query on writing multiple sheets in excel i just shared my zip file already if you don’t mine can you have a look.the thing is it is not scraping the data as expected in excel sheet,plz have a look at my excel file in that and also have a look at my xaml file also.and thanks for your valuable time spending on this.

14

Hi there!

Appreciate your assistance with an issue that i am facing.

I have managed to extract a date from an email which is in this format, “04 November 2019” and have already converted in to a string and assigned it to a variable, DateA.

My question here is, how can i convert the variable, DateA, to specific format lets say “dd-mm-yyyy”. Tried the Datetime.ParseExact method but the error message “String was not recognized as a valid DateTime”.

I’m guessing that “04 November 2019” is not a valid DateTime? Is there any work arounds for this? Looking forward to your response buddy!

1 Like
15

@R11

Welcome to the uipath community.

Try below expression and it will give you required date.

   String requiredDate = DateTime.ParseExact(yourDate, "dd MMMM yyyy", System.Globalization.CultureInfo.InvariantCulture).Tostring("dd-MM-yyyy")

Here, yourDate = “04 November 2019”

6 Likes
16

Really appreciate your prompt response Mr Lakshman! And great news, this worked perfectly! Wishing you a great week ahead! Cheers :slight_smile:

3 Likes
17

@R11

Glad to help you. Happy Automation :grinning:

1 Like
18

I could use some help because I must be doing something wrong.

I have string variable pdate that I am creating from a transaction item that is a date in format yyyy-MM-dd

I need to actually get it into date format so I have an assign for a variable pdateNew that I have has type DateTime.

I am using this code to try and convert, I want to get it to MM/dd/yyyy

pdateNew=
Datetime.ParseExact(pdate.ToString,“yyyy-MM-dd”,System.Globalization.CultureInfo.InvariantCulture). ToString (“MM/dd/yyyy”)

I am getting the error: “Cannot assign from type System.String to type System.DateTime in Assign Activity Assign”

Would appreciate any help. Thanks!

19

@Chris_Livesay If you want only MM/dd/yyyy format you can get it in the form of String , But in the form of Date , I don’ think it’s possible

In your Assign Statement Dont use ToString(“MM/dd/yyyy”) since your variable is of DateTime it cannot hold a string value

20

The format is not critical, I can have it be something different but I need a valid date format because I am going to have to do a lesser than, greater than comparison to another date.