Convert date to worded date

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??

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,

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

1 Like

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