Convert date to worded date

[ciaramkm (Murph)]

Hi. I’m currently trying to convert this string 17/02/2020 12:00:00 AM into this format Monday, 17 February 2020.

I successfully managed to get it in a different format CDate(NowDate).ToString(“dd/MM/yy”) but what I’m trying to do above is proving to be more difficult. Any idea what would the suitable formula be to convert to this Monday, 17 February 2020??

[Yoichi]

Hi,

Hope the following helps you.

strData = "17/02/2020 12:00:00 AM"
strResult = Datetime.ParseExact(strData,"dd/MM/yyyy hh:mm:ss tt",nothing).ToString("ddddd, dd MMMMM yyyy")

Regards,

[ciaramkm (Murph)]

That did the job! Thank you for your help!!