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'

What is exact meaning of Database Checkpoint in QTP 9.2 and what are the different types of the database check points?

0 Answers  

can i compare two databases using QTP ?

0 Answers  

Hi All, I need Code For how to export Pass\Fail status to excell sheet without using QC. Thanks Balaji

3 Answers  

how to add run-time parameter to a datasheet?

1 Answers   Mphasis, Ordain Solutions,

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

0 Answers  

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

6 Answers   GE,

Hi, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?

0 Answers   BirlaSoft,

Deal All, Recently i face one interview question in one company. str="test12@#3456" In This i want to print like special character and numeric ,word in one script please tell me how to write the code for this Thanks Balaji

1 Answers  

What do you mean by checkpoints in qtp?

0 Answers  

How to find array size in qtp?

0 Answers  

Does QTP support flat files? If yes what are those?

2 Answers  

To which environments does QTP supports ?

1 Answers