Trouble In index server usage!!!!!!!!!!!!!!!!

[Parvez]

I tried diffrent Querry to get files in diffrent manner.
In on type where i was tring to search it in a manner that I get all files
between 2 dates and all i get an exception saying that Date format is not
matching with VT_FileTime..........Then i converted the Datetime value
FROMDATETIME.ToFileTime() still it doesnt work.I am getting an Exception . It
would be grat if any one helps Below is my Querry and The Exception.Other
Problem is that I dont get any result For "Vpath" attribute
"Select FILENAME,SIZE,PATH from SCOPE() Where create >= " +
FromDate.ToFileTime() +" Order By Create"

System.Web.Services.Protocols.SoapException: Server was unable to process
request. ---> System.Data.OleDb.OleDbException: Cannot convert


127878714000000000 to type VT_FILETIME
at FileOpService.FillDataSet(String Connect, String Command, String
TableName) in d:\BSE\CUS_Service\App_Code\FileOpService.cs:line 209
at FileOpService.ListFileFrom(DateTime FromDate) in
d:\BSE\CUS_Service\App_Code\FileOpService.cs:line 124
--- End of inner exception stack trace ---

[Parvez]

Post by Parvez
I tried diffrent Querry to get files in diffrent manner.
In on type where i was tring to search it in a manner that I get all files
between 2 dates and all i get an exception saying that Date format is not
matching with VT_FileTime..........Then i converted the Datetime value
FROMDATETIME.ToFileTime() still it doesnt work.I am getting an Exception . It
would be grat if any one helps Below is my Querry and The Exception.Other
Problem is that I dont get any result For "Vpath" attribute
"Select FILENAME,SIZE,PATH from SCOPE() Where create >= " +
FromDate.ToFileTime() +" Order By Create"
System.Web.Services.Protocols.SoapException: Server was unable to process
request. ---> System.Data.OleDb.OleDbException: Cannot convert
127878714000000000 to type VT_FILETIME
at FileOpService.FillDataSet(String Connect, String Command, String
TableName) in d:\BSE\CUS_Service\App_Code\FileOpService.cs:line 209
at FileOpService.ListFileFrom(DateTime FromDate) in
d:\BSE\CUS_Service\App_Code\FileOpService.cs:line 124
--- End of inner exception stack trace ---

I got the solution .Guys.The date format should be yyyy/MM/dd

[Eric]

Be sur your date is formated like 'YYYY-MM-DD'
in the query.

Ex :

Select FILENAME,SIZE,PATH
from SCOPE()
Where create >= '2005-12-24'
Order By Create"

Post by Parvez
I tried diffrent Querry to get files in diffrent manner.
In on type where i was tring to search it in a manner that I get all files
between 2 dates and all i get an exception saying that Date format is not
matching with VT_FileTime..........Then i converted the Datetime value
FROMDATETIME.ToFileTime() still it doesnt work.I am getting an Exception . It
would be grat if any one helps Below is my Querry and The Exception.Other
Problem is that I dont get any result For "Vpath" attribute
"Select FILENAME,SIZE,PATH from SCOPE() Where create >= " +
FromDate.ToFileTime() +" Order By Create"
System.Web.Services.Protocols.SoapException: Server was unable to process
request. ---> System.Data.OleDb.OleDbException: Cannot convert
127878714000000000 to type VT_FILETIME
at FileOpService.FillDataSet(String Connect, String Command, String
TableName) in d:\BSE\CUS_Service\App_Code\FileOpService.cs:line 209
at FileOpService.ListFileFrom(DateTime FromDate) in
d:\BSE\CUS_Service\App_Code\FileOpService.cs:line 124
--- End of inner exception stack trace ---