Hi I am having issues with one of the values in the data table(read from an excel file), for some odd reasons it’s in MM/dd/yyyy format even though in excel it’s in dd/MM/yyyy format.
I am trying to use compare date activity to calculate the difference in days(System.datetime.now) but for that to happen i need to convert data table date value to dd/MM/yyyy format. and i am converting that using “Convert.ToDateTime(GRI_SentDate.ToString(“dd-MM-yyyy”))" and now i am getting an error “Assign: String was not recognized as a valid DateTime”. though i did notice it did change the format for first 2 values.
Is there any other way to calculate the difference in days?