473,480 Members | 1,864 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How to query using today's date?

greeni91
61 New Member
Hi All,

I have been working on a database for a few weeks now and I have hit a bit of a snag.

I have to make a set of reports detailing which machines need maintenance in the upcoming month. I have setup the report but I need to apply a filter of some sort, Query?, to show only the machines needing done in this month.

The field I need to search is called M Next Date and the format of the field is Date/Time (custom) "mm/yyyy". When I tried running the query with the Date() function I get no results but I know that there are 2 machines needing this check from my main form.

Can anyone help me please??

/Sandy
Aug 20 '10 #1
1 1404
NeoPa
32,556 Recognized Expert Moderator MVP
Greeni91:
Can anyone help me please??
I expect so Sandy.

What are you working with at the moment?

What is the range you're looking for when filtering [M Next Date]?
Aug 20 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
8370
by: Phil Powell | last post by:
The date field I believe is of type datetime, but I'm sorry I have absolutely no idea how to put today's date into a datetime column using ASP and SQL Server. Folks, I'm a LINUX guy!!! This is a...
1
2030
by: EnriqueM | last post by:
One question: I created an access database that has been extremely useful in my work. I dont' even know at what level of knowledge I am at. I read a lot about how to create a database, created many...
5
8333
by: Janet Chapman | last post by:
I am creating a database for a video shop and in the loans table want there to be a field for date taken, with a default value of today. Trying to write =today() as in the help gives an error,...
1
1352
by: Paul | last post by:
how should i format the conditional parameter on the WHERE clause to limit the query on a date field. Let say I want to limit the query from today up to a month back, or today up to 20 days...
2
3314
by: Cy | last post by:
I have a custom access 2000 database, that has contracts with starting and ending dates. What I'd like to be able to do, is key in a date, say today 9/2/05 and get a list of all "current"...
4
2766
by: Kun | last post by:
i have a form which takes in inputs for a mysql query. one of the inputs is 'date'. normally, a user has to manually enter a date, but i am wondering if there is a way to create a button which...
5
2683
by: M Skabialka | last post by:
I am creating my first Visual Studio project, an inventory database. I have created a form and used written directions to add data from a table to the form using table adapters, data sets, etc. ...
22
2486
ChaseCox
by: ChaseCox | last post by:
Alright so I have a new problem with my form. I would like The default of my combo box to be today's date, since one of the filtering options for my query is ship date, which allows the user to...
1
9394
by: MarkK | last post by:
Hi all I've used Access for years but I'm not a programmer so I need some help... I want to regularly transfer files into a folder but want them to be tagged with the date of transfer (today's...
1
1188
by: gramcc | last post by:
Hi i am new to access and queries. I'm trying to create a query that uses the different between today's date and the date an applicaiton was entered to return data and i cannot get my query to...
0
7059
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7103
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6758
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7010
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5362
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4499
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1311
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
572
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
203
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.