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?
Hi @ezFlow
You need to use the substring function. Here it is
Above expressions are as follows:
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogSaved 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))
Hi @ezFlow
You sure substring(variables('DOBVAR'),1,4) is working? The index starts with zero.
See my results below.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogOn 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
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogUser | Count |
---|---|
95 | |
45 | |
21 | |
18 | |
17 |
User | Count |
---|---|
142 | |
50 | |
43 | |
40 | |
31 |