QTP11.0 - Date format is changed as text while executing the QTP script.

[Tarik Sheth]

Hi Automation Tester,

1. you should format and set the entire column for the time as a particular format like HH:MM or HH:MM:SS like that.
2. Always have the same format as of your system date and time format, you can change it from the Control panel and regional settings.

That being said, you can also add the time in the following way.
DateAdd(interval,number,date)
yyyy - Year
q - Quarter
m - Month
y - Day of year
d - Day
w - Weekday
ww - Week of year
h - Hour
n - Minute
s - Second

adding the time in the above manner will get you rid of the issues.