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 |
what is qtp automation frame work,what is the use of that frame work?
64 Answers Cap Gemini, IBM, iGate, TCS,
Which company is better amdocs or techm ???
How to track the execution time?
what is meant by function library?Public and private functions in function library? if private functions are applicable for only for the particular test means then y we have to add those to function library?
To which environments does QTP supports ?
Where you are storing your script?
How to test login page by using QTP
.how will you load the object during runtime
What are the ordinal identifiers in web page?
what is output value in QTP and how it can be used in automation testing
Explain about the Test Fusion Report of QTP?
How many add-ins comes by default with qtp?