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?
You need to use the substring function. Here it is
Above expressions are as follows:
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))
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
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.