String was not recognised as a valid time error in Build Data table

Hi @Sneha2369

So in the same statement just add as below :-

DateTime.ParseExact(CDate(strvar).ToString("dd/MM/yyyy"),"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Or another way is just do like below :-

CDate(strvar).ToString("dd/MM/yyyy")

This both way will eliminate the timing part at the end of the date

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer: