- Use Assign Activity
To- HireDate
Value - In_transactionItem.SpecificContent(“Hire Date”).toString("dd-MM-yyyy).
*HireDate is a variable with datatype as Datetime.
*(“Hire Date”) Keep Column name as present in excel.
- For Comparing HireDate
Current Date = Datetime.Now.toString(“dd-MM-yyyy”)
You can compare with Both the dates as needed.
Thanks & Regards
Loveleet saini