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'

Hi All As per the requirements i have to copy the data from word document to excel sheet using the QTP Note : Data in word document is in tabular format i.e there is 80 rows and 5 columns table Can any body provide code for this ? Thanks in advance Regards Test123Test

1 Answers  

How can the functions inside DLL be called from QTP? i mean How can i use those functions(Inside DLL) in QTP

1 Answers  

How to test whether the navigation i.e. from one page to another is working r not using QTP for web based application

1 Answers  

What is the main differece between QTP 9.0 and 9.2

1 Answers   VeriSign,

1)Difference Between Value & RawValue?

2 Answers   Wipro, Zensar,

You say it is a bug but developer say it is not a bug then what will you do?

7 Answers   Hewitt, Tech Mahindra,

What is Data driven Testing Frame work.Anybody can expain it in Detail.. Pls anybody can give the answer.. Thanks in advance...

1 Answers   Navis,

Tell about descriptive programing in qtp8.2?

4 Answers   GE,

For which type of projects the iterative model is not suitable?

0 Answers  

Hi,All How to change background color of a cell in excel using qtp and that too with out using Excel Object.(I am importing the excel sheet by using ImportSheet method)

1 Answers  

Why do you create a text checkpoint on a Web application? What is the purpose of the Close method?

0 Answers  

How to perform action on objects, If two objects have the almost the same name ? example : Object 1 : "Entry of Items" Object 2 : "Items" Whenever I ask QTP to perform an action on Object 2 it performs action on Object 1. Note: The two objects are present in an Oracle Application tree.

2 Answers   Wipro,