Hi,
I am facing problem while executing a Datetime.ParseExact in the assign activity. But i when print it in message box using hardcoded value same syntax is working fine.
Input(Excel)
Assign:
row(“Datetime Parse(Out)”) = Datetime.ParseExact(row(“Out”).ToString,“HH:mm:ss”,system.globalization.cultureinfo.invariantculture).ToString(“h:mm tt”)
Message Box:
Datetime.ParseExact(“11:15:00”.ToString,“HH:mm:ss”,system.globalization.cultureinfo.invariantculture).ToString(“h:mm tt”)
Error:
DateTime ParseExact: String was not recognized as a valid DateTime
I have referred various posts and microsoft docs, still I am unable to figure what I am missing here…
Please assist.