Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

example-date format is 01-jan-09 in QTP.How to convert this
format to 01-01-09?

Answer Posted / pratatp

i also not find the straight way.
dat=datevalue("01-jan-09")

d=day(dat)
m=mon(dat)
y=year(dat)

con_dat=d&"-"&m&"-"&right(y,2)

msgbox con_dat

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i am trying to automate yatra.com,in that site, when i go to automate the Leaving from field showing as a WEBEDIT, but when i enter 1 or 2 char, it displaying dropdownlist, i try to use keyboard automation to select the item from that list but it is not possible, can anybody help he. Thans for posting the Answer

4104


How we can import data from database?

1276


How to create Reusable and Multiple Actions?

2241


i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji

2163


Our company is having a windows client server application developed in vb.net. so there is a treeview and i am not in a position to record the click events in QTP. so kindly help. Vivek

2118


I am having major problems with some DB Table Checkpoints I add to my script. I 35 web based applications recorded and each has DB Table Checkpoints insert but only 1 script isn't recognizing the DB Table Checkpoints for some reason. I've checked the DB connections and the info in the Library Functions and still only this one script out of 35 doesn't recognize the DB Table Checkpoints. Can someone please help me figure out why only this one script out of 35 that's hitting the same database is having a problem.

2255


If object is not recognized by qtp but the object is standard object what is your approach?

1089


give me an example where u used good judgement and logic in solving a problem

3908


How to modify object property in qtp ?

1055


What is Unicode Compatibility?

2092


How to find the difference between 2 dates in qtp?

1106


hi Friends ,willany body tell me what is the Scope for the automation Testing inht Future is their Or not And what is the Top Most Level in the testing section according the Pay scale

2106


Want to verify notepad reports using QTP framework or any other BV script method. Can anyone share the method to achieve it? Eg. Person Name is the header and the actual name is John then how can we verify weather person name is John

2636


how to write the descriptive programming in QTP for remove the object value and substitute, with a variable then call the validation from excel

2437


Give the syntax to import/export xls into qtp.

1095