Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
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 the first digit of ...
|
|||||||
|
|||
|
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 | |
|
|
Similar Threads
|
||||
| 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 |