Having Trouble with using Dates in Excel with Katalon

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?

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?

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

1 Like

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

No problem :slightly_smiling_face: