Covert String into date

[ezFlow]

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?

[abm]

Hi @ezFlow 

You need to use the substring function. Here it is

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

[ezFlow]

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]

Hi @ezFlow 

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

See my results below.

Thanks

[ezFlow]

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]

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