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
2 Likes
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:
