Hi,
I use formula =TEXT(WORKDAY(TODAY(),2), “dd-mmm-yyyy”) in my Excel & use it as Katalon data file.
Today is 13 Sep. Excel shows 17-Sep-2018 correctly but Katalon shows 11-Sep-2018.
When change ‘2’ in the formula to 1, 3, 4, 5 or 6, it works fine.
When change to 7, Excel shows 24-Sep-2018 correctly but Katalon data file shows 18-Sep-2018.
Some screen shots attached. Does anyone else see the same thing ?
Please help.
Many Thanks,
KatalonQuery.docx
Hi,
Again today is 14 Sept. “=TEXT(WORKDAY(TODAY(),6), “dd-mmm-yyyy”)” in Excel shows 24-Sep-2018. In Katalon Data File, it shows incorrect 18-Sep-2018.
When the 6 in the formula is changed to other number, it works fine.
Does anyone know if this is a bug ? In POI used by Katalon maybe ?
Thank you
Hi, any idea if this is a bug ? So not recommended to use formula when using Excel as Data File ?
Thank you,
I could reproduce the problem you reported.
I have enough reason to believe it is a bug in Katalon Studio.
KD9632.png
Lo,
A possible workaround would be creating CSV file from your Excel, and let Katalon read the CSV.
@Katalon team
Perhaps this post should be moved to the Bug Reports category.
kazurayam said:
Lo,
A possible workaround would be creating CSV file from your Excel, and let Katalon read the CSV.
Thank you kazurayam, for now I’m using Java, Groovy methods to calculate the dates instead of reading from data file.