SOAtest using dynamic Excel Datasources
I use _dynamic _Excel sheet (XSLX) as a datasource for the DBtool to make sql inserts. The Excel =TODAY -formula is used to put today's date in a field. This works well, also with highly concatenatied queries. OK.
However on the long run it seems that SOAtest is treating such a datasource as static, because when I repeat the test, a previous date is used. Even when refreshing the tst by double-clicking on the tst-box, this does not give the desired result.
Only when creating a new tst and attaching the same Excel sheet, the correct date is parsed and hereby the old tst's are also 'refreshed'.
Thanks in advance and have a good weekend.