String yyyyMMdd to date and back to string (ex:20170928)

[Jay_Chacko (JC)]

I am having trouble converting a string that is formatted in the yyyyMMdd to dateFormat then ultimately back to string again to MM/dd/yyyy. I keep getting “Assign: String was not recognized as a valid DateTime.”

How to fix this ?

string :“20170928”

parsing code i used so far

DateTime.ParseExact( stringDate, "yyyy/MM/dd",System.Globalization.CultureInfo.InvariantCulture)
Date.Parse(stringDate)

Both don’t work and give same error

My flow

[Yoichi]

Hi,

Can you try the following expression?

DateTime.ParseExact( stringDate, "yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture)

Regards,

[Jay_Chacko (JC)]

thanks man , added the / instead of just yyyyMMdd( used yyyy/MM/dd