I am trying to pass the excel start date and end date to the webpage.
The excel context in as show below:
Then, the date and month in excel file and output in my wegpage are reverse. So, i use this function as well: Date.ParseExact(“dd/mm/yyyy”,strDate.ToString.Trim,System.Globalization.CultureInfo.InvariantCulture).ToString(“mm/dd/yyyy”) to reverse the date and month.
But, when i try use this function in both start date and end date, only start date can give me the output while end date give me this error:
and here is my workflow:
Can anyone pls help me? Thanks.