Answer / saravanaraja

Balaji First you understand the question.

Ex: 01-jan-09 in QTP. How to convert this
format to 01-01-09?

MsgBox date. This is simple to view the Current date.

They asked How to convert 01-jan-09 TO 01-01-09.

Answer / brahma naidu kapa

It's very simple question;
no need to write all the excessive code.
Please convert the given value into date format by using
the CDATE Function

val = "01-jan-09"
Conv_Val = cdate(val)
msgbox Conv_Val

Result : "01-01-2009"

Answer / kiran kallepu

please find below code
givenDate = "01-jan-09"
DD = Day(givenDate)
msgbox DD
MM= month(givenDate)
msgbox MM
YY=year(givenDate)
msgbox YY

sysdate=DD&"-"&MM&"-"&YY
msgbox sysdate

Answer / swati

I could not find any straight way to do this, however it
had to be done in a customized manner:

newDate = day(date) & "-" & month(date) & "-" & year(date)

Answer / 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

Answer / harish

val = "01-jan-09"
Conv_Val = cdate(val)
msgbox Conv_Val

newvalue = replace(Conv_Val,"/","-")


values = split(replace(newvalue,right(newvalue,4),right(newvalue,2)),"-")

for i = 0 to ubound (values)

if Len(values(i)) <2 then
temp = temp & "0" & values(i) & "-"
Else
temp = temp & values(i)
End If
Next

msgbox temp

'Result : "01-01-09"

Answer / balaji

Hi You Can Use This Code

DD= Day(now)
msgbox DD
MM= month(now)
msgbox MM
YY=year(now)
msgbox YY

sysdate=DD&"-"&MM&"-"&YY
msgbox sysdate

Answer / rajendra

Please find code below:

'get date
StrDay=Day(now)
'get Month
StrMon=Month(now)
'get Year
'Stryear=year(now)

' Assemble the Date according to the ur requirement ( ex:01-
01-2010)
ExpDate=StrDay&"-"&StrMon&"-"&'Stryear
msgbox ExpDate

Answer / vishakha b

If you are talking about some date value in global sheet,
here is the procedure:
Select the entire column where the Date is put in the
format: 01-jan-09
Right click, go to Format => Custom Number. Select 'Date'
under 'Category' and type the format you want into 'Type'
text box. Click 'OK'

Username field having some string mistake like"user naem".what type of testing i prefer to test spell check.

6 Answers   GE,

How the exception handling can be done using quicktest professional (qtp)?

0 Answers  

In an interview, what r the general questions asked in SQL which is realted to testing ?pls give me anwser to this question?

0 Answers  

How can we retrieve the links from a web page where links are dynamically changing(for eg take a online shopping website) and then we have to click on all the links present in the webpage and go to the repective pages and again come back to the first page..

2 Answers  

what is the defference between QTP 8.2 and 9.0and 9.2? plz tell me

6 Answers  

What is the difference between a Function and Procedure in QTP?

0 Answers   Wells Fargo,

Give me some scripts for 1). checking webpage links (counting links,opening web pages,counting child elements)

2 Answers   CIL,

Hi, my requirement is to make a query in SQL using QTP. And i have to get the results of that query and i have to use those results for future testing. I created a driver but i dont know the code for using this Driver. please help me by providing the solution for y requorement

0 Answers  

Suppose one object is changed in a project after delivering the project.Where we will update that object? it can be present in many scripts so can we update all the scripts?

1 Answers   IBM,

I want to test my vb.net solution file using qtp. Does Qtp test only .exe file?

0 Answers  

suppose there r 10 action in a test i want to execute action 5 to 10 how would i do that

2 Answers  

How can i select multiple items from a WebList bOX USING QTP

3 Answers   DuPont, Syntel,