Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Rotterdam
    Posts
    17

    Question Unanswered: default date in access project form

    Oke, here is the problem.

    I'm having a form in an access project. One of the fields is a date/time field. I'd like to make the date of today the default value for this field.

    When I put this statement (convert(datetime,convert(varchar,getdate(),1),1))
    in sql server database as the default for this field it gives me right value. When I put this statement in the form it gives me error messages, telling me that the "convert" function is not allowed in this field.

    But I want the putting of the today date in my form and not in the database.

    Anyone out there with bright ideas

    Thank you for thinking with me.
    Last edited by peter1970; 02-23-04 at 18:14.
    Peter Dorsman

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: default date in access project form

    Access doesn't recognize the CONVERT command which is a SQL server function, you must use this instead:

    CDate(Now())

    http://www.geocities.com/scirocco_ha/DataControl.htm
    In abundance of water only the fool is thirsty. Bob Marley.

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Or just Date().

Posting Permissions

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