So I was hoping to do a little boundary testing in an excel-based MSTEST unit test involving dates. The values are actually in decimal format "yymmdd" since the back-end system is an iSeries. Being "clever", I put a formula in a few of the cells to generate a value for TODAY() so I could test that particular scenario.
Yesterday, the tests worked. Today, they don't because -- duh -- the ODBC connection to Excel does not force calculation of the formulas. So, my test data gets stale.
So, anybody managed to jump over this particular hurdle with MSTEST Data-driven tests?
Thanks in advance for the spare brain power.