Convert "October 04 at 3:00pm" to DateTime variable

[Sami_Syed]

I am creating this topic again because the last solution is not working.

I added the following code to convert:
Datetime.ParseExact(Split(timePostedSTR.tostring," “)(0).tostring+” “+Split(timePostedSTR.tostring,” “)(1).tostring+” "+now.tostring(“yyyy”),“MMMM dd yyyy”,system.globalization.cultureinfo.invariantculture)

However I am now getting this error:

I believe it is because of ‘yyyy’, while the input does not give a year.

So my question is how can I modify this so it works without the year as well?

[Palaniyappan (Palaniyappan P)]

@Sami_Syed

timePostedSTR

Fine
May I know what is the value of timePostedSTR
Without year it would be like this

Datetime.ParseExact(Split(timePostedSTR.tostring," “)(0).tostring+” “+Split(timePostedSTR.tostring,” “)(1).tostring,“MMMM dd”,system.globalization.cultureinfo.invariantculture)

But that won’t be an issue
We need to validate the input once
Then we could surely resolve this

@Sami_Syed

[Yoichi]

Hi,

Probably, you should set the 2nd argument of ParseExact method to “MMMM d yyyy” instead of "MMMM dd yyyy" because your log shows the input string is not “October 04” but “October 4”.

Regards,

Yoichi

[Sami_Syed]

@Palaniyappan

May I know what is the value of timePostedSTR

This variable is the input. I am scraping it from the web.
an example of timePostedSTR would be “October 04 at 3:00pm”

[Sami_Syed]

@Yoichi

because your log shows the input string is not “October 04” but “October 4”.

Makes sense I Will try both ways