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

[staceylaney]

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?

[RezaDorrani · Accepted solution]

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

[staceylaney]

That was SO simple - thank you!

[Anonymous]

Hi Reza, I'm trying to apply this concept to my scenario. Could you guide how to fix this. Basically, I'm creating a file in sharepoint from previous input (Power BI extract). Iam looking to append only Date to this rather than have UTC now. The formula above doesnt seem to work. Could you guide?

[Anonymous]

It worked for me now.

[JohnGorena]

or more accurately adjust for your time zone

formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'MM/dd/yyyy')

The expression above shows a format like 01/10/2022 for Central Standar Time.

[ROKSTA1972]

@RezaDorrani can you convert UTC time to New Zealand Standard Time and then also format the date to "dd,mm,yy" in Power Automate

[JohnGorena]

formatDateTime(convertFromUtc(utcNow(), 'New Zealand Standard Time' ),'dd,MM,yyyy')

will produce a format like 24,03,2022