Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2008
    Posts
    42

    Unanswered: Setting partial date

    I have a date/time field with (h:m). Is there a way to add day, month, and year to the field without modifying (h:m)?

    Thanks
    Drew

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    Use the DateAdd() function.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Nov 2008
    Posts
    42
    Quote Originally Posted by garethdart
    Use the DateAdd() function.
    Thanks for the reply.

    When I use the dateadd function, it replaces the h:m. Is there a way to do it where the h:m data is not disturbed?

    I used the following dateadd function to test:

    Code:
    UPDATE [DOW created] 
    SET start = dateadd("d",1,05);
    Thanks
    Drew

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    Where are you doing this from so I can test please? Form behind code, VBA Module, Query?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

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