Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How I can pass a DateTime parameter from an ASP page?

Status
Not open for further replies.

mishicato

Programmer
Jan 21, 2003
1
PE
my report use a Store Procedure from SQL Server 7.0
it returns a DateTime Field

then I need to filter by this Field

I try to make the follow formula:

obj.SelectionFormula = "{sp_Reg001.CodigoAgencia} = 8 AND {sp_Reg001.FechaProceso} >= DTSToDateTime ('2003/01/20 15:39:18')"

but I get a message that tell me "the name of fields is unknow"

what is wrong?

Help me please
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top