Help with UPDATE query

  • Thread starter Thread starter Shaun
  • Start date Start date
S

Shaun

Hi,

I have two columns in my Bookings table of type DATETIME -
Booking_Start_Date and Boking_End_Date. How can i update every row so that
all of the times for Booking_Start_Date are 09.00 and all of the times for
Booking_End_Date are 17.30, without affecting any of the dates?

Thanks for your help
 
Use an Update query (Update on Query menu in query design).

In the Update row under the Booking_Start_Date field, enter:
DateAdd("h", 9, DateValue([Booking_Start_Date]))

In the Update row under the Booking_End_Date field, enter:
DateAdd("n", 1050, DateValue(Booking_End_Date))

Run the query.

Explanation:
DateValue() returns the date without any time component.
DateAdd() adds the desired number of hours or minutes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With a DATETIME Query 1
Creating an update query that uses multiple parameters 2
Operation must use an Updatable Query 2
VBA - retrieve data on last create named range from previous inserted named range 0
How to validate time format from a text field? 2
Passing DateTime to query, comparing 1
Updating Table with another tables values 6
Counting multiple memberships 1

Back
Top