web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Covert String into date
Power Automate
Unanswered

Covert String into date

(0) ShareShare
ReportReport
Posted on by 104

I'm pulling a string: 19761120, which I need to add to a SharePoint date field.

How do I convert or split the string to a format like 1976/11/20  that a Date field can accept?

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @ezFlow 

     

    You need to use the substring function. Here it is

     

     

    image.png

     

    Above expressions are as follows:

     

    substring(string(outputs('Compose')),0,4)
    substring(string(outputs('Compose')),4,2)
    substring(string(outputs('Compose')),6,2)
     
    Here is my test result
     
    image.png
  • ezFlow Profile Picture
    104 on at

    Saved the string as a DOBVAR, and made it work.

    concat(substring(variables('DOBVAR'),1,4), '/', substring(variables('DOBVAR'), 5, 2), '/', substring(variables('DOBVAR'), 7, 2))

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @ezFlow 

     

    You sure substring(variables('DOBVAR'),1,4) is working? The index starts with zero.

     

    See my results below.

     

    Thanks

  • ezFlow Profile Picture
    104 on at

    On all the Date field the substring starts with 0.
    This field (all comes from an excel that is generated by 3rd party software), worked with 1. 
    Perhaps there is a space

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @ezFlow 

     

    Yes thats the only reason that worked. I would say use the trim() to make sure the space is removed and start the index at 0. Thats the way I would do it. 

     

    If you happy with my earlier response please mark it as solution accepted.

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard