web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Automate - Building Flows
Answered

Convert date format from DD/MM/YYYY to timestamp

Like (0) ShareShare
ReportReport
Posted on 19 Jun 2020 14:08:15 by 10

I have a string date in the UK format "DD/MM/YYYY" when I insert this into a sharepoint date column it gets parsed as "MM/DD/YYYY". 

 

So when I insert "01/02/1990" (1st Feb 1990) it gets inserted as 2nd Jan 1990.

 

Is there a way to convert  "DD/MM/YYYY" to a timestamp (YYYY-MM-DD) so that the date can be inserted correctly. ?

 

I have looked at the formatDateTime function but the first argument to that expects only YYYY-MM-DD ?

  • Verified answer
    Community Power Platform Member Profile Picture
    on 19 Jun 2020 at 17:35:02
    Re: Convert date format from DD/MM/YYYY to timestamp

    Hi!

    You need to transcript your date into timestamp like that: 2020-06-19T17:26:02.1821723Z

    So you need:

    1. Use split expression and separate your date

    2. Use concat 

     

    concat(split('DD/MM/YYYY','/')[2],'-',split('DD/MM/YYYY','/')[1],'-',split('DD/MM/YYYY','/')[0],'-00T00:00:00.0000000Z') Here u have timestamp 🙂 

     

     

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete