Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    128

    Unanswered: Concatenate Date and Time

    Hi,
    I have a textbox X in the form F. It contains adate but with out time.
    How can I write in the query to take the date with the time.
    I mean [Forms]![F]![X] and to ade the time 05:30:00

    Best regards...

  2. #2
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    =format([FileName].[DateField],"MM/DD/YY")&" 05:30:00"

    TD

Posting Permissions

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