Results 1 to 2 of 2

Thread: Dates, empty dates - the question is how?

  1. Jul 23rd, 1999, 04:59 PM #1
    amacfarl
    amacfarl is offline

    Thread Starter
    New Member
    Join Date
    Jul 1999
    Posts
    4

    Post

    Trying to set a Visual FoxPro Date field to Null via DAO/ODBC results in an error.

    The FoxPro ODBC driver does not use Null for an empty date. You can set the date field to 12/30/1899 instead. The Visual FoxPro ODBC driver translates this value into an empty date.

    The question is what do you do with Microsoft Access? I am stuck!!!!
    Reply With Quote Reply With Quote
  2. Jul 24th, 1999, 09:47 PM #2
    googie
    googie is offline
    New Member
    Join Date
    Jul 1999
    Location
    St Peters, MO, USA
    Posts
    15

    Post

    In the design mode in Access if you use Date/Time as the Data Type you can set the "Required" property to no. When you add records do not put a value in the Date field and it will treat it as a Null value.

    Hope this helps.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width