Prepare for your Next Interview
This is a discussion on First digit of date is getting truncated within the QTP forums, part of the Software Testing category; HI in our application date accepts the value dd/mm/yyyy i am parameterizing in this field when i enter the date for eg 09/01/2007 into data table ...
|
|||
|
First digit of date is getting truncated
HI in our application date accepts the value dd/mm/yyyy i am parameterizing in this field when i enter the date for eg 09/01/2007 into data table the first digit of the date i.e zero is getting truncated how to overcome this
NOTE : [This question was asked by ferozbm] |
| Sponsored Links |
|
|||
|
Re: First digit of date is getting truncated
If I get your question correctly, you are saying that you enter dates into the datatable and retrive it using a parameter into a field on the application you are testing.
To solve the truncating 'Zero', you may put in an IF statement to check the # of strings coming from the datatable in each of the month and day sections. If it is less than 2, then add a 'Zero' to the front. Or, you may just use a format date function. Something like this; Format(DTBox, "dd/mm/yyyy") |
|
|||
|
Re: First digit of date is getting truncated
Navigate this way ,
Got to your Script folder --> Default excel sheet --> Format the date cell box as u want ( U cant do that in the global sheet) and Save it so that it wont get truncated when u r actally running the scripts |
|
|||
|
Re: First digit of date is getting truncated
Quote:
This will work for both internal datasheet or external datasheet ![]() |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 3-Digit Numbers Puzzle | admin | Brainteasers | 4 | 06-17-2008 05:58 AM |
| Date Function in Oracle | Robert | Oracle | 4 | 02-16-2007 06:15 AM |
| release date | Aam23 | LoadRunner | 1 | 01-28-2007 03:18 PM |
| Eight digit number | Manojks | Brainteasers | 1 | 01-04-2007 07:52 AM |
| 5 digit number.... | psuresh1982 | Brainteasers | 2 | 11-29-2006 01:49 AM |