Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    108
    Provided Answers: 1

    Unanswered: Create Date Time from Two Different Fields

    Hi,

    Using Access 2016.

    How can I create a Date/Time Field in Query from two other fields in the query?

    Field1 : GetTimeIn: Hour([TimeOut])-[Hrs_Regular] (e.g 22)
    Field2: GetDateIn: DateValue(Format([TimeOut],"mm/dd/yyyy")) (e.g. 11/21/2015)

    I tried to Concatenate these two fields using Format GetDateTimeStamp: Format([GetDateIn] & " " & [GetTimeIn],"Medium Time")
    But that is returning a string 11/21/2015 22. Im trying to get to 11/21/2015 10:00:00pm

    Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    why do you need to concatenate in the first place. assuming you have stored the timeout value correctly (ie as a date time value then its all down to formatting
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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