Having Trouble with using Dates in Excel with Katalon

Web Testing
,
1

So I’m having trouble getting Katalon to read my dates correctly. So i, using sendKeys using my dates from the excel sheet i created.
println(findTestData(“ClockIds”)
.getValue(1,6))
The actual Value is: 10312020
What Katalon is printing is: 116287

In Excel i tried change my column into Text Format but its still giving me the same results. Any Solutions?

2

Can you share any of the following?:

1.) A screenshot of the data opened in excel (not as a Katalon data object).
2.) A screenshot of the data opened in Katalon.
3.) Can you upload the workbook to this topic?

3

not really because its for work but i can do the two screen shots

1 Like
4

Sorry it was a user error not katalon lol :rofl:

5

No problem :slightly_smiling_face: