Answered

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

(1) Share

Report

Posted on by 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?

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (1)

Verified answer

RezaDorrani 12,143 on at

Like (23)

Report

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

2 people found this reply helpful.

Was this reply helpful? Yes No
staceylaney 63 on at

Like (1)

Report

That was SO simple - thank you!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It worked for me now.

Was this reply helpful? Yes No
JohnGorena 79 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
ROKSTA1972 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
JohnGorena 79 on at

Like (1)

Report

formatDateTime(convertFromUtc(utcNow(), 'New Zealand Standard Time' ),'dd,MM,yyyy')
will produce a format like 24,03,2022

Was this reply helpful? Yes No
MitheshRpa 162 on at

Like (0)

Report

If i use this syntax , i am getting it as text , but not date.

Was this reply helpful? Yes No
JohnGorena 79 on at

Like (0)

Report

Write the format that you want or the format that works in a DATE Field.. Put it in a date field and not a text field. Does that work?

Was this reply helpful? Yes No
JohnGorena 79 on at

Like (1)

Report

I posted this somewhere on this forum before but I cannot find it... Here are examples from my notes....

01)
utcNow()
2022-01-10T20:27:13.9480796Z
02)
formatDateTime(utcNow(),'yyyy-MM-dd tH:mm:ss')
2022-01-10 P20:27:13
03)
formatDateTime(utcNow(),'yyyy-MM-dd TH:mm:ss')
2022-01-10 T20:27:13
04)
formatDateTime (addHours(utcNow(), -6),'yyyy-MM-dd (H:mm:ss)')
2022-01-10 (14:27:13)
05)
convertFromUtc(utcNow(), 'Central Standard Time' )
2022-01-10T14:27:13.9480796
06)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyy-MM-dd (HH:mm:ss)')
2022-01-10 (14:27:13)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyyMMdd')
20220110
07)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyy-MM-dd , H:mm')
2022-01-10 , 14:27
08)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyyMMdd-HHmm')
20220110-1427
09)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyyMMdd @HHmm')
20220110 @1427
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyyMMdd')
20220110
10)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyy-MM-dd (H:mm:ss)')
2022-01-10 (14:27:13)
11)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyy-MM-dd (HHmm)')
2022-01-10 (1427)
12)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyy-MM-dd (H:mm:ss)')
2022-01-10 (14:27:13)
13)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyy-MM-dd (HH:mm:ss)')
2022-01-10 (14:27:13)
14)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyy-MM-dd (hh:mm:ss tt)')
2022-01-10 (02:27:13 PM)
15)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyy-MM-dd (h:mm:ss tt)')
2022-01-10 (2:27:13 PM)
16)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'g')
1/10/2022 2:27 PM
17)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'MM-dd-yyyy, h:mm tt')
01-10-2022, 2:27 PM
18)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'MM-dd-yyyy, h:mm:ss tt')
01-10-2022, 2:27:13 PM
19)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'yyyy-MM-dd, h:mm tt')
2022-01-10, 2:27 PM
20)
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'MM/dd/yyyy')
01/10/2022
formatDateTime(convertFromUtc(utcNow(), 'Central Standard Time' ),'MM/dd/yyyy h:mm tt')
01/10/2022 2:27 PM

Was this reply helpful? Yes No