Friday, 22 January 2010

Issue - Data Table formats

Overview:
When a script is converted from QTP9.5 to QTP10 the date/formatting is forgotten.

Impact:
Medium: quick to fix, but may affect many tests

How to replicate:
In QTP9.5 set a DataTable value to =now()
In QTP10, when we open this script, the date will read as a meaningless double and not a date.
Note - I do not want to claim that this happens 100% of the time - I may've missed a step with recognising why this is happening.

To solve:
Right click the cell
Select Format
Select Date (dynamic)
Save your test and the problems is solved


Overview

This blog is designed to give an overview for the how's/why's and what's to upgrading from QTP9.5 to QTP10.0, based purely on recent experiences on client site.