example-date format is 01-jan-09 in QTP.How to convert this
format to 01-01-09?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 14 Yes | 3 No |
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"
Is This Answer Correct ? | 13 Yes | 5 No |
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
Is This Answer Correct ? | 8 Yes | 4 No |
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)
Is This Answer Correct ? | 6 Yes | 5 No |
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
Is This Answer Correct ? | 2 Yes | 2 No |
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"
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 1 Yes | 4 No |
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'
Is This Answer Correct ? | 0 Yes | 7 No |
Please give me the steps to carry out datadriven in QTP8.2
What are the features and benefits of Quick Test Pro(QTP)?
HI ALL I AM WORKING AS A AUTOMATION ENGINEER FROM PAST 2 MONTHS IN QTP,MY QUESTION IS IF I OPEN THE BROWSER FIRST & THEN THE QTP LATER MY OBJECT SPY WILL NOT WORK,Y IT IS SO..IF U HAVE THE ANSWER PLZ MAIL ME AT AKSHAR.MYSORE@GMAIL.COM
hi This is Harish.1. What is object repositery .2. what is frame works in QTP,what is keyword driven frame work,explain it and how to associate the folders.3.the build is developed in java, can we write scripting in vb .4.what is discriptive progaram,how to write it.5.what is process of QTp testing.6. how to associate the shared repository. 7.what is implicit and explicit 8.what is runtime data please replay me regards Harish
what are the metrics in general we use in testing.
can test automation improve test effectiveness?
In qtp, how you can exit for loop?
I have a Webtable object in my shared object repository, say WT1, which has different index value in 2 different versions, one version having WT1's index value as 1 and other version having WT1's index value as 2. how could i use same test script to identify the WT1 object having different index values.
What is the Limitations of Testing ?
WHat is Object Identification and Object Spy?
What is runtime objects and test objects? What is the difference between them?
When you open QTP, how many sheets you can see?