Extracting Date from Email
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@KamenRider you could do this very efficiently with Power Automate or Automation Anywhere
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @Deano478 , however our office don't have power automate. How about python, any ideas? Guys from out there please.
Kamen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@KamenRider
use outlook email tool to pull the data from the mail
once pulled this can be converted using the formula tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
 
Looking forward for your assistance.
Thank,
Kamen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@KamenRider
body and datetime received will pull the required.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
.Edited.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
