cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
staceylaney
Level: Powered On

Format Date/TIme from utcNow() to Date Only and REMOVE Time?

I'm tryin to feed the DATE ONLY into a SharePoint text field, using the utcNow().  I need to EXCLUDE/remove the date, and currently have it formatted as:

 

formatDateTime(utcNow('MM-dd-yyyy'))

 

The date is now fine, but how do I remove the time?

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Format Date/TIme from utcNow() to Date Only and REMOVE Time?

Hi @staceylaney 

 

use expression

 

formatDateTime(utcNow(),'MM-dd-yyyy')

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

2 REPLIES 2
Dual Super User
Dual Super User

Re: Format Date/TIme from utcNow() to Date Only and REMOVE Time?

Hi @staceylaney 

 

use expression

 

formatDateTime(utcNow(),'MM-dd-yyyy')

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

staceylaney
Level: Powered On

Re: Format Date/TIme from utcNow() to Date Only and REMOVE Time?

That was SO simple - thank you!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (7,145)