Help with Date field

Results 1 to 2 of 2

Thread: Help with Date field

  1. #1
    Tara Guest

    Default Help with Date field

    I had a date field I had as text but changed in Access to a short date field so I could sort by it. Now when I try to input a new record I get an error <BR><BR>"Provider error &#039 80020005&#039 <BR><BR>Type mismatch. <BR><BR>/admin/modify_results.asp, line 253"<BR><BR>It seems this must be related to the date field, but how do I fix this?<BR><BR>Thanks<BR>Tara <BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Help with Date field

    When you insert your new value just make sure you use...<BR><BR>fieldname = CDate(whateveryourstringis)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts