Changing the date format in QTP9.0

[Arun]

Hi,

 

I have to change the system date to the format DD-MMM-YYYY i.e. 03-FEB-2009... Can anyone help me??

 

Your help is much appreciated.

 

Thanx,

Arun.

[kapil sachdeva]

Hi

 

 

i think u can use the FormatDateTime date function in vbscript , that should work..

try it.

[Roman Zilber]

Why do you need it?

Control Panel==>Regional and Language Options==>Format

[Sreedhar Mallipeddi]

hi

Use the below code

        StrDateFormat  = FormatDateTime(StrDate, 1)
        StrDateFormat1  = Split (Trim(StrDateFormat),",",-1,1)
        StrDt  = Right(Trim(StrDateFormat1(1)),2)
        StrMonth  = Ucase (Left(Trim(StrDateFormat1(1)),3))
        fDateformat  = StrDt&"-"&StrMonth&"-"&Trim(StrDateFormat1(2))

On Tue, Feb 3, 2009 at 12:15 PM, Arun <aruu...@gmail.com> wrote:

--
Mallipeddi Sreedhar
91-9848871279

[Arun]

Hi,

 

This worked fine.. Thanx for ur assistance.

 

Thanx,

Arun.

[Tarun Lalwani]

You can also use a VBScript function that has lot more formatting
options for dates

http://knowledgeinbox.com/articles/vbscript/formatting-date-and-time/