Covert String into date

(0) Share

Report

Posted on by ezFlow

100

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:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

abm abm 32,852 Most Valuable Professional on at

Like (1)

Report

Re: Covert String into date

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

Was this reply helpful? Yes No
ezFlow 100 on at

Like (0)

Report

Re: Covert String into date

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))

Was this reply helpful? Yes No
abm abm 32,852 Most Valuable Professional on at

Like (0)

Report

Re: Covert String into date

Hi @ezFlow

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

See my results below.

Thanks

Was this reply helpful? Yes No
ezFlow 100 on at

Like (1)

Report

Re: Covert String into date

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

Was this reply helpful? Yes No
abm abm 32,852 Most Valuable Professional on at

Like (0)

Report

Re: Covert String into date

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

Was this reply helpful? Yes No