cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Extract time from the Date time output

Hello,

 

I converted the time to the way I want. Now I want to extract just the time into a variable. 8:24 PM in a variable. 

How can I do that?

Lana_0-1596075001324.png

 

Thank you in advance!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Resident Rockstar
Resident Rockstar

Re: Extract time from the Date time output

@Lana 

Did you try using the Format  String to be Short Time Pattern as below ,, this will extract the time part only

Mira_Ghaly_0-1596080007887.png

If this post helps you with your problem, please mark your as Accepted solution.

 

If you like my response, please give it a Thumbs Up.

 

MG (Naturally Curious)

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Resident Rockstar
Resident Rockstar

Re: Extract time from the Date time output

@Lana 

Did you try using the Format  String to be Short Time Pattern as below ,, this will extract the time part only

Mira_Ghaly_0-1596080007887.png

If this post helps you with your problem, please mark your as Accepted solution.

 

If you like my response, please give it a Thumbs Up.

 

MG (Naturally Curious)

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

View solution in original post

Highlighted
Helper II
Helper II

Re: Extract time from the Date time output

You could also use the substring function to extract the portion that you want. Oddly enough, I wrote a blog post about it yesterday: https://powerplatformpod.com/2020/07/28/environment-variables-part-3-and-bonus-substring-function/

 

Another tool in the tool belt at the very least!

 

Cheers,

 

DC

Highlighted
Helper II
Helper II

Re: Extract time from the Date time output

Thank you so much! I had clearly overlooked that option.

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!

Users online (5,021)