If: String was not recognized as a valid DateTime. help

[Iman_Shafeeq]

hi community
need help with this issue where i try to get the publication date of news website and i dont where to fix it anymore.
this is my workflow

assign : System.Text.RegularExpressions.Regex.Match(DateWEbsite, “(?<=, ).+ \d{4}”).ToString().Trim()
if condition: CDate(in_TransactionItem(“Date”).ToString).Date = DateTime.Parse(DateWebsite, New System.Globalization.CultureInfo(“my-MY”)).Date

i tried to match it with the one in the excel file. the format is like this

[Yoichi]

Hi,

Can you share content of DateWebsite?

Regards,

[Iman_Shafeeq]

hi sorry do you want the website content?

[Yoichi]

Nope, can you share content of DateWebsite variable?

[Yoichi]

HI,

Can you try to set Breakpoint at the IF activity and Debug run? Workflow will stop there, then check Locals panel?

Regards,

[Iman_Shafeeq]

sorry do you mean this one?

[Iman_Shafeeq]

here is the result

[Yoichi]

Hi,

According the above image, DateWebsite variable is empty. So it’s necessary to review settings of GetText activity and/or regex pattern.

Regards,

[Iman_Shafeeq]

hi this is my current setting for get text activity

and this is the regex pattern: System.Text.RegularExpressions.Regex.Match(DateWEbsite, “(?<=, )\w+ \d{1,2}, \d{4} @ \d{1,2}:\d{2}[ap]m”).ToString().Trim()

[Yoichi]

Hi,

First, can you check output of GetText activity? Is it empty? If so it’s necessary to review selector settings. From the above image, it seems necessary to remove aaname attribute because it’s dynamic.

Regards,

[Iman_Shafeeq]

hi i try remove the aaname but i still got the error If: String was not recognized as a valid DateTime. i also check the get text output but it return null

[Yoichi]

@Iman_Shafeeq

i also check the get text output but it return null

It’s necessary to modify selector settings of GetText. It may be also good to add anchor.

Regards,

[ashokkarale]

@Iman_Shafeeq,

It’s clearly an issue of Get Text Selector. Fix the selectors and you should be fine.

Thanks,
Ashok