Considerations if you are experiencing "wrongly formatted" dates when working with Excel and Kryon RPA
When working with "dates" in Excel in the context of Kryon RPA you may run into the problem that the date format is not correctly interpreted. Example: Kryon RPA retrieves the value "mm/dd/yyyy" as opposed to what you see when you open the .xlsx file manually, for example, "dd/mm/yyyy". To address this, it is important to first understand how dates actually "work" (in Excel) and how they tie to your (system) regional settings. Please review the following article: https://www.excelcampus.com/functions/how-dates-work-in-excel/ As such, when working with dates (coming from Excel files) in Kryon RPA, consider the following if you are indeed experiencing the above-mentioned format(ting) issues: You can (re-) format the date in Kryon RPA using Advanced Commands, such as the "Format date" command (if date formats are "reliably wrong" in the same fashion all the time) or a combination of the "Split" and "Set value" commands If this proves too unreliable, you can make sure (if applicable) you a