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 are using the "actual values" setting in the Advanced Command(s) you are using to retrieve the "date" values. This will retrieve a given "date" as a number (see above article) and you can programmatically convert the date yourself. Note: This can get complicated, so try other approaches first
- Finally, you might record and use an Excel macro to format the Excel file to correspond to the (date) format you require (record the macro in Excel and make sure it works, then copy it to the corresponding Advanced Command in Kryon RPA)
Following the above guidelines and methodologies will ensure you always have the desired (date) format(s) at your disposal when working in/with Kryon RPA.
