If I enter [OrderDate]+(22/24), I get 10:00pm but if I go [OrderDate]+(22/24/60), I get 12:22AM, and [orderdate]+(22/24/60*35), it comes out 12:50PM. How do I get a value like 10:35PM?
Kevin Robertson
@Reply 2 years ago
I would be easier to do this in 2 parts. The first formula is in your question.
Then use the DateAdd function.
Kevin Robertson
@Reply 2 years ago
Kevin Robertson
@Reply 2 years ago
You can do it with one formula, like this:
[OrderDate] + (22 / 24) + (35 / 24 / 60)
Tannim HallmanOP
@Reply 2 years ago
Thank you. That single formula was exactly what I was looking for.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 27.
