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"
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

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