Now is greater than 24 hours of given date

Posted on 2013-10-10
Medium Priority
Last Modified: 2013-10-11
Hello Experts,

I have two columns, Date & Now.  They are both formatted as General Date

Date                                               NOW
10/10/2013 4:11:00 AM      10/10/2013 4:59:33 PM
9/5/2013 5:41:00 PM                           10/10/2013 4:59:33 PM

I want to be able to query for [NOW] >24 hours from [Date].  A simple "Yes" "No" answer would suffice.

Any simple solution for an iif expression here?

Your help is greatly appreciated.  I am sure that I must be overthinking this.

Thank you
Question by:ammiewinds
LVL 59

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 39564194

LVL 53

Expert Comment

by:Gustav Brock
ID: 39564704
You may wish to be accurate to the minute, and Format can be used:



Author Closing Comment

ID: 39566373
Thank you, Jim.  I was totally over thinking this.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question