I see default 12/09/1899 in my date column.
Here are the expressions I used.
1)======threw the 1899 error
======threw an error saying string was not recognized as a valid date Time
DateTime.ParseExact(in_qi_TransactionItem(“ActiveDate”).ToString, “MM/dd/yyyy”, CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)
Can anyone alternative expression? Thanks!
It’s coming from the correct column. And it is a formula column. the date values to be carried to the next template with the date format. Please let me know if you want me share the excel file with you. Thanks!
The file was already read using the classic read range. My Bot account does not have O365 license as a result of that I do not use Excel Process Scope. If possible, I want to resolve using the expressions. Please let me know if I misunderstood you. Thanks a lot!
Let me try to explain a little bit
Column E is populated when there is data in Column C. We then populate a template column (on another separate file) data from column E after making sure that the data in Column E is converted to MM/dd/yyyy format. Can you please look into the attached excel file.
Here is also the expression I was trying to use that is resulting in 1899 error