New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
QTP11.0 - Date format is changed as text while executing the QTP script.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
QTP11.0 - Date format is changed as text while executing the QTP script.
Automation Tester Offline
Junior Member
**
Posts: 1
Threads: 1
Joined: May 2014
Reputation: 0
#1
Not Solved 05-28-2014, 11:07 AM
Hi,

I am using QTP11.0.
I am using extenal file[excel] for testdata.
In one of my scripts, in excel, for one cell i used the formula for date.
the date format is "=Now()+"2:30"

This formula first i tried in testdata file. few days it works fine.after that i did not work well. then I gave the same date fromula in test script file[excel] it self.

when we open the file and see it shows as date .But In both cases it is changed as text while executing the QTP scripts. the cell data shows as "Hide 158".

I tried in different ways. but no luck.

If any body knows the solution please post the answer.

Thanks in Advance...
Find
Reply


Messages In This Thread
QTP11.0 - Date format is changed as text while executing the QTP script. - by Automation Tester - 05-28-2014, 11:07 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  error when executing an UFT automation script alexalloza 0 1,429 10-30-2018, 06:17 PM
Last Post: alexalloza
  swfwindow object name getting changed after each run saniya 1 1,539 10-10-2018, 09:02 PM
Last Post: TheGlovner
  How to append date to xls file using qtp datatable methods? yona34 1 1,505 05-04-2018, 08:56 PM
Last Post: Ankur
  Executing via create "RES"xx folder? nishitd 0 1,135 03-07-2018, 01:09 AM
Last Post: nishitd
  QTP not recognizing date calendar kQTPs 1 3,485 12-20-2017, 11:21 PM
Last Post: harikrishna

Forum Jump:


Users browsing this thread: 1 Guest(s)