Microsoft Flow – Format Dates with formatDateTime

Getting a date

Recently quite a few citizen developer asked me how to format dates in Flow. Quite often people want to send dates in an email, however formatting these dates doesn’t seem to be that easy.

In my example I’m just going to take the current date and send it out by email:

This now gives me the following email:

OK, that is ugly!

Format the date using formatDateTime

Now I add the formatDateTime function and a format string ‘dd-MM-yyyy’.

and my date will appear in the European format of day-month-year

 

Advertisements

5 thoughts on “Microsoft Flow – Format Dates with formatDateTime

  1. So simple, when you know how. I went bald trying to get a sensible date format to work when Flow first came out. Bloody stupid US date formats! (UTC, is better, if unfriendly). Thanks Pieter

    Like

  2. Hi, Please can you help me with a date format issue.. I tried your example above and it worked, but when I try to use this “formatdatetime” expression on one of my own date fields it doesn’t work. For example, my date field “DateRequired”
    Can you please show me how this is put together in a string so that it displays in UK date format (i.e. non US format)?
    Many thanks
    Sue

    Like

    1. Hi Sue,

      You might find that different types of datasources present dates in different ways. I would collect the dates in question in a Compose action and then compare the date formats. Flow will look at the date as a string so that means that the exact text format is important.

      Like

Please leave a comment or feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.