Having Trouble with using Dates in Excel with Katalon


#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


#4

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


#5

No problem :slightly_smiling_face:


#6