How to get custom formatted date from qtp

[QADBA]

If your date format is an string (from an inputfield or sth like that), you can dismember the string in different parts:

Code:

year = left(YYYY-MM-DD, 4)
month = left(right(YYYY-MM-DD, 5), 2)
day = right(YYYY-MM-DD, 2)

newdateformat = month & "/" & day  & "/" & year

You have to adapt the code if you have no leading "0", 23.5.2008 instead of 23.05.2008.

Hope this helps.