Extracting Date from Email

[KamenRider]

Hi guys,

Is there a way I could get the date in the email below using Alteryx automation or other means aside from copying and pasting it using the report text tool in Alteryx?

I'd like to get or extract "Wed 5/8/2024 6:29 PM" and convert/format it to "Wednesday, May 08, 2024 6:29 PM".

I'd like also to extract "20240508 06:28:41" exactly as it is.

Anyone please. Please help.

Kamen

[KamenRider]

Hi @Raj ; @BS_THE_ANALYST 

Frankly speaking, I didn't know what to enter on the blank provided in Outlook tool that is why I am asking for examples. However, below is the screenshot from selecting Date Time Received, Date Time Sent and Body with errors. Is it also possible to enter partly of the subject name to narrow down the search?

 

Hoping for your response and assistance. Thanks,

Kamen

[Raj]

@KamenRider Try using outlook 365 tool

[KamenRider]

HI @Raj 

Sad to say, I don't have Outlook 365 Input Tool in the Alteryx.

☹️

Kamen

[Raj]

@KamenRider 
you can get it from here
https://community.alteryx.com/t5/Community-Gallery/Outlook-365-Tool/tac-p/1160791#M1554

Also this will help
 Outlook 365 Input Tool (alteryx.com)
Set Up Microsoft Azure API Application (alteryx.com)