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?
Solved! Go to 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
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
That was SO simple - thank you!
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?
It worked for me now.
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.
@RezaDorrani can you convert UTC time to New Zealand Standard Time and then also format the date to "dd,mm,yy" in Power Automate
formatDateTime(convertFromUtc(utcNow(), 'New Zealand Standard Time' ),'dd,MM,yyyy')
will produce a format like 24,03,2022
User | Count |
---|---|
23 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
44 | |
29 | |
24 | |
23 | |
23 |