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