Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    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

    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:

    In abundance of water only the fool is thirsty. Bob Marley.

  3. #3
    Join Date
    Feb 2004
    Chicago, IL
    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