Data File data different from that in Excel.

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.

Fine, anything you like.