Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSQuery date criteria using 'today's' date

Status
Not open for further replies.
LinsayPatterson

LinsayPatterson

IS-IT--Management
May 7, 2020
2
AU
I've been following a previous (now closed) thread on this & see there was not a conclusive solution.

For returning the date using MSQuery:

>=GetDate()


For returning today minus 65 days use:

>=(GetDate())-65
 
Sort by date Sort by votes
Hi,

Welcome from Up Over (Texas) to Down Under! My mate is my wife and my knife is not so big.

Do you have a question?

Just an observation on returning today's date. It all depends on the database you are accessing. So if you have a question, please include the database you are tapping.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
 
Upvote 0 Downvote
On further inspection I found some issues with that previous code & found this one is much better:

>=current_date()-62
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
335
SkipVought
S
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
177
ladyck3
ladyck3
MM1963
  • Locked
  • Question
Excel - Unique count using a criteria 2
Replies
19
Views
333
SkipVought
S
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
983
Andrzejek
Andrzejek
Tropometer
  • Locked
  • Question
Help with dates
Replies
1
Views
168
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top