>I am trying to post a date from asp to a foxpro database. I keep getting an "Invalid Data Type" error. The field is formatted as a date field in foxpro. Can anyone help me to resolve this? Here is a sample of the asp code (very simplified):
>
>
>today = now
>
>Set Conn = Server.CreateObject("ADODB.Connection")
>conn.open "DSN=test"
>SQL="INSERT INTO foxtable(date) Values (" &_
>"'" & today + "')"
>
>Set RS = Conn.Execute(SQL)
>set rs=nothing
Make sure it isn't coming through as DateTime.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer