Date and Time Formatting in Power Automate

| Muhammad Yaseen

To use the formatDateTime () function, you need to have a date time, such as that from utcNow () and pass it into the formatDateTime() function. Then you can create your desired date & time output.

An example of this would be formatDateTime(utcNow(), ‘dddd, MMMM dd, yyyy’). This will produce: Friday, May 07, 2021,

For your reference below is the table in which you find the characters for your Date Time formatted string

Character

Description

Example

“d”

Day of the month

1

“dd”

Day of the month but includes the initial 0

01

“ddd”

Abbreviated name of the day 

Fri

“dddd”

Full name of the day 

Friday

“M”

Month number

5

“MM”

Month number but includes the initial 0

01

“MMM”

Abbreviated name of the month 

Jun

“MMMM”

Full name of the month

June

“y”

Year number (last character of the year example using 2021)

1

“yy”

Year number (last 2 characters of the year example using 2021)

21

“yyy”

Year number (last 3 characters of the year example using 2021)

021

“yyyy”

Full year

2021

h

Hour

1

hh

Hour but includes the initial 0

01

H

24 Hour Clock

4

HH

Hour but includes initial 0

04

m

Minute (example: 5)

5

mm

Minute but includes the initial 0

05

s

Second

7

ss

Second but includes initial 0 

07

t

AM/PM but only the initial letter

A

tt

AM/PM

AM

“f”

The tenths of a second in a date and time value.

2009-06-15T13:45:30.6170000 -> 6

“ff”

The hundredths of a second in a date and time value.

2009-06-15T13:45:30.6170000 -> 61

“fff”

The milliseconds in a date and time value.

6/15/2009 13:45:30.617 -> 617

“ffff”

The ten thousandths of a second in a date and time value.

2009-06-15T13:45:30.6175000 -> 6175

“fffff”

The hundred thousandths of a second in a date and time value.

2009-06-15T13:45:30.6175400 -> 61754

“ffffff”

The millionths of a second in a date and time value.

2009-06-15T13:45:30.6175420 -> 617542

“fffffff”

The ten millionths of a second in a date and time value.

2009-06-15T13:45:30.6175425 -> 6175425

“F”

If non-zero, the tenths of a second in a date and time value.

2009-06-15T13:45:30.6170000 -> 6

“FF”

If non-zero, the hundredths of a second in a date and time value.

2009-06-15T13:45:30.6170000 -> 61

“FFF”

If non-zero, the milliseconds in a date and time value.

2009-06-15T13:45:30.6170000 -> 617

“FFFF”

If non-zero, the ten thousandths of a second in a date and time value.

2009-06-15T13:45:30.5275000 -> 5275

“FFFFF”

If non-zero, the hundred thousandths of a second in a date and time value.

2009-06-15T13:45:30.6175400 -> 61754

“FFFFFF”

If non-zero, the millionths of a second in a date and time value.

2009-06-15T13:45:30.6175420 -> 617542

“FFFFFFF”

If non-zero, the ten millionths of a second in a date and time value.

2009-06-15T13:45:30.6175425 -> 6175425

“g”, “gg”

The period or era.

2009-06-15T13:45:30.6170000 -> A.D.

“K”

Time zone information.

2009-06-15T13:45:30, Kind Utc -> Z

“z”

Hours offset from UTC, with no leading zeros.

2009-06-15T13:45:30-07:00 -> -7

“zz”

Hours offset from UTC, with a leading zero for a single-digit value.

2009-06-15T13:45:30-07:00 -> -07

“zzz”

Hours and minutes offset from UTC.

2009-06-15T13:45:30-07:00 -> -07:00

“:”, “.”

The time separator.

2009-06-15T13:45:30 -> : (en-US)

“/”, “-“

The date separator.

2009-06-15T13:45:30 -> / (en-US)

“string”, ‘string’

Literal string delimiter.

2009-06-15T13:45:30 (“arr:” h:m t) -> arr: 1:45 P

%

Defines the following character as a custom format specifier.

2009-06-15T13:45:30 (%h) -> 1

\

The escape character.

2009-06-15T13:45:30 (h \h) -> 1 h

Any other character

The character is copied to the result string unchanged.

2009-06-15T01:45:30 (arr hh:mm t) -> arr 01:45 A


Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.


M
Chief Architect, Founder, and CEO - a Microsoft recognized Power Platform solution architect.

About The Blog

Stay updated with what is happening in the Microsoft Business Applications world and initiatives Imperium is taking to ease digital transformation for customers.


More About Us

We provide guidance and strategic oversight to C-Suite and IT Directors for on-going implementations. Feel free to give us a call.

1 331 250 27 17
Send A Message

Ready to Start?

Get a personalized consultation for your project.

Book a Meeting