Convert datetime to MMDDYYY

Hello team,

I am getting received date from email using CurrentMail.Headers(“date”).ToString
I have a datetime in extracted into a string variable as “07/26/2022 02:37:38”

I want this to be extracted in 2 formats

07262022

07262022_023738

Can you please help me in converting into the upper 2 formats?

Regards,
Gokul

Hi @gokul1904

Try this

image

CDate(CurrentMail.Headers(“date”)).toString(“MMddyyyy”)
CDate(CurrentMail.Headers(“date”)).toString(“MMddyyyy_HHmmss”)

above similar to Varuns answer

With the Hint of:

1 Like

Hello @gokul1904
Try this
For 12 hrs format

DateTime.ParseExact("07/26/2022 02:37:38","MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("MMddyyyy")
DateTime.ParseExact("07/26/2022 02:37:38","MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("MMddyyyy_hhmmss")

For 24hrs Format

DateTime.ParseExact("07/26/2022 02:37:38","MM/dd/yyyy HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("MMddyyyy")
DateTime.ParseExact("07/26/2022 02:37:38","MM/dd/yyyy HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("MMddyyyy_HHmmss")

image

DateTime.ParseExact(CurrentMail.Headers(“date”).ToString, “MM/dd/yyyy hh:mm:ss”,System.Globalization.CultureInfo.InvariantCulture).tostring(“MMddyyyy_hhmmss”)

try this

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