Date format changes from 'yyyy-mm-dd hh:mm:ss' to 'mm/dd/yyyy'

[Rashmi Vishwanath]

HI ,
Any one let me know while fetching date feild from datatable in QTP its taking as "mm/dd/yyyy h:mm" format even though in datatable its displaying as "mm/dd/yyyy h:mm:ss AM" by the time of running it takes as "mm/dd/yyyy h:mm"

Code:

rows=browser("").Page("").WebTable("").RowCount
For j=0 to rows
var=Browser("").Page("").WebTable("").GetCellData(j,1)
var2=dataTable("Col1",dtlocalsheet)
If var=var2 Then
fromdate=Browser("").Page("").WebTable("").GetCellData(j,2)
frmTabledate=datatable("FromDate",dtlocalsheet)
if fromdate=frmTabledate then
Reporter.reportevent Micpass. "Success". "Added"
End if
End if
Next

Here for frmTabledate its taking as mm/dd/yyyy h:mm where fromdate is in "mm/dd/yyyy h:mm:ss AM" format hence not going inside loop.

Please some one help me out as i am a fresher

[Rashmi Vishwanath]

Please any one guide me.. I am stucked up

[soumen]

While inserting the date in the datatable column start with an single quote (e.g: '1/13/2012 5:29:35 AM). This will store the date as a string format in the datatable. While retrieving the value from the datatable you will get it as a string. Then you can use it for your comparison as required.