Scenario of date

Hello dear robot masters, I have a list of dates in my email’s body It is more to a full of texts. But, this date is remain unknown, so I try to extract it and put in message box.

1.Read email’s inbox
2. Filter the numerous list of mail in the body email.
3. Compare the current ones

@f39b242a4f84ba555bd3 Can you please post the error that you are facing.

currently, i have no error. But, i cant change what inside body to be a general format for uipath to read (“MM-dd-yyyy”). So, hoping there is a solution

@f39b242a4f84ba555bd3 Yes you can change the date format.Please share the sample text to change the date format

On Apr 16, 2019 @ 10:41 am, Heinz wrote:

@f39b242a4f84ba555bd3 Follow below steps

1)Assign string V1= On Apr 16, 2019 @ 10:41 am, Heinz wrote:

2)Assign String V1= System.Text.RegularExpressions.Regex.Match(V1,“[A-Za-z]{3}[\s][\d]{2}[,][\s][\d]{4}”).ToString

3)Assign String V1 = CDate(V1).ToString(“MM-dd-yyyy”)

Now V1 Will have result 04-16-2019

Thank you!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.