Hi there, I have an asp page whe

[sweetleaf]

Hi there,

I have an asp page where I am trying to update a record.
One of the fields is a date field and I'm getting a "not a valid month" error from oracle..

<the date field is on the last line &quot;movement_date&quot;>
connection.Execute(&quot;UPDATE equipment SET from_loc = '&quot; & trim(g_fromloc) & &quot;', to_loc = '&quot; & trim(g_toloc) & &quot;' ,model_no = '&quot; & trim(g_model) & &quot;', upc_code = '&quot; & trim(g_upc) & &quot;', direction = '&quot; & trim(v_dir) & &quot;', movement_date = '&quot; & v_movedt & &quot;',......

does anyone know how to format or cast this?

Thanks!

 

[baddos]

<% If IsDate(v_movedt) Then
CDate(v_movedt)
Else
Response.Write &quot;Invalid Date&quot;
Response.End
End If %>