Get received date Mail outlook?

[Maria99]

I want to get received date Mail outlook.
Now I use item.Headers(“Date”)
It show output Tue, 21 Sep 2021 11:00:33 +0700

But I want output format dd/MM/yyyy

Please guide me about it.

[Gokul001 (Gokul Balaji)]

Hi @Maria99

Try to use Below Expression

DateTime.ParseExact(Split("Tue, 21 Sep 2021 11:00:33 +0700","+")(0).TrimEnd,"ddd, dd MMM yyyy HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Regards
Gokul

[lakshman (Ganta lakshman)]

@Maria99

Try below expression.

            CDate(item.Headers(“Date”)).ToString("dd/MM/yyyy")

[Palaniyappan (Palaniyappan P)]

@Maria99

Tue, 21 Sep 2021 11:00:33 +0700

Hi

Hope this expression would help you resolve this

If you have the date In a string variable then use a assign activity like this

stroutput = DateTime.ParseExact(Split(Strinput.ToString,”:”)(0) ,“ddd, dd MMM yyyy HH”,system.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Cheers @Maria99