DateTime.ParseExact problem

Help Activities
, , ,
1

Hi guys, so I’m reading the date using Read Cell with PreserveFormat ON. The output value is 2/28/22 as in m/d/yy format. After I use DateTime.ParseExact(dataTabel_str,“m/d/yy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”) the output value is 28/01/2022 where it should’ve been 28/02/2022.
Any thoughts?

2

Hi @s0biesky

Can you try with expression

CDate("InputString").Tostring("dd/MM/yyyy")

Regards
Gokul

3

I solved it after I read what I wrote xD.
The problem was that I used “m/d/yy” where it should’ve been “M/d/yy”.
Thank you!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.