I need to read date and time from separate columns and paste it in website.
I have month as string suppose “JAN FEB etc…” in the website.
The actual date 08/02/2020 in excel.
I’ll get month from date as startDate.Month.ToString and format to Datetime.ParseExact(month ,“MM”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMM”)
but im getting month as 2 and error is thrown as “Assign: String was not recognized as a valid DateTime.”
Even for time im getting single digit
actual time- 15:00
getting as hrs as 15 and min as 0.
want mins in mm format
Thanks in Advance…