Extracting Date from Email

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

Workflow

Date Time

Accepted answers

All comments

Deano478

@KamenRider you could do this very efficiently with Power Automate or Automation Anywhere

KamenRider

Thanks @Deano478 , however our office don't have power automate. How about python, any ideas? Guys from out there please.

Kamen

Raj

@KamenRider
use outlook email tool to pull the data from the mail
once pulled this can be converted using the formula tool.

KamenRider

HI @Raj,

Is that the outlook input tool? can you please give an example how this is being done. It seems it has space for password?

outlook confi.PNG

Looking forward for your assistance.

Thank,

Kamen

KamenRider

HI All,

Hi All / @Raj @Deano478 @binu_acs

Does anyone of you knows how to extract date and message like using python in Alteryx?

Need assistance please.

Kamen

Raj

@KamenRider
body and datetime received will pull the required.

Raj

.Edited.

KamenRider

HI @Raj

What do you mean. Do you any idea to share with?

Please advsie

Kamen

BS_THE_ANALYST

@KamenRider you put a picture of how to configure the tool. Raj said click on the body and datetime checkboxes to pull the info you want from your request

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?