How to change dateformat picked from Excel data

Hi, i’m using the excel cell (Test Data) to pick today date and set text in a date field. But katalon studio transform date to MM/DD/YYYY. I need DD/MM/YYYY. How to change this setting?

Version: 5.3.0

Build: 1


Work around to allow DD/MM/YYYY format from excel data file.
Solution one: Enter the date with an apostrophe ’ at the start
e.g. '21/05/2018

Solutions two: If you have the date in cell A2 then in another cell use the formula
e.g. =TEXT(A2,“DD/MM/YYYY”)

1 Like

Hello, I’m having issues about date format, it assigned different dates, please help, I attach my config: