cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Convert string (01 Sep 2006) to Date

Hi guys,

I have an e-mail alert that gives me a date in the format 'dd MMM yyyy' e.g. '01 Sep 2006' or '04 Jul 2018'.  How can I convert this to a usable date that I can create an Event with?

Loads of stuff out there on date formats, but nothing I've found that resolves my issue. Hope you can help.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Convert string (01 Sep 2006) to Date

Hello @JumpjJet 

 

Try using the Convert time zone action:

Jcook_0-1596643272447.png

 

 

The output looks like:

Jcook_1-1596643317903.png

 

 





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Convert string (01 Sep 2006) to Date

Hello @JumpjJet 

 

Try using the Convert time zone action:

Jcook_0-1596643272447.png

 

 

The output looks like:

Jcook_1-1596643317903.png

 

 





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




View solution in original post

Highlighted
Frequent Visitor

Re: Convert string (01 Sep 2006) to Date

Excellent.  That's spot on.  Many thanks

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,971)