i have a query and i put date() as creteria in deb coloumn to get filtred values of date/time of today
but in my report issu of this query it still empty.
deb format in my form is : "dd-"mm"-yy "hh:nn
please help me to resolve problem
If your date field has a time element in it, then you cannot compare to Date as that has no time element.
So use the datevalue() function on your date field and compare that to date().
Google how to use the function.
the problem is not that you tell me
if i make Année(Date()) or Mois(Date()) as createria in my other queries my report load date values normaly..the problem is just in date() mean today and date()-1 mean yesteday.
What are you actually showing?
One cannot see the names of the fields. You really do not make it easy for people to help you, do you?
You can only compare like for like.
Try using a date range. That will then largely overcome the time element issue.
@Gasman has told you the problem, but you haven't grasped the reasoning behind the principle.
All dates in Access are actually a date and time expressed as a decimal number and formatted so that we understand what they represent.
Your date values have a time portion :
08/09/2022 12:49:53
Your Criteria by using Date() is actually :
08/09/2022 00:00:00
Which Access truncates and displays as 08/09/2022
So your query is actually saying
Code:
SELECT * FROM yourTable
WHERE YourDate field = 08/09/2022 00:00:00
And none of your dates actually match that value.
If you remove the time portion from your data it will work :
Code:
SELECT * FROM yourTable
WHERE DateValue([YourDateField]) = 08/09/2022
@Gasman has told you the problem, but you haven't grasped the reasoning behind the principle.
All dates in Access are actually a date and time expressed as a decimal number and formatted so that we understand what they represent.
Your date values have a time portion :
08/09/2022 12:49:53
Your Criteria by using Date() is actually :
08/09/2022 00:00:00
Which Access truncates and displays as 08/09/2022
So your query is actually saying
Code:
SELECT * FROM yourTable
WHERE YourDate field = 08/09/2022 00:00:00
And none of your dates actually match that value.
If you remove the time portion from your data it will work :
Code:
SELECT * FROM yourTable
WHERE DateValue([YourDateField]) = 08/09/2022
You're tired? Sometimes the solution is to just take a break. Do something else for a while. Get some fresh air. Even take a nap. Come back to the problem refreshed and ready to take a different approach, or try something else.
If, on the other hand, there is a specific concept you do not understand, sometimes the tried and true method is "Try It and See What Happens". That's how many of us attack our problems. It's a good feeling when you finally get it.
Best try another hobby then?
You have been advised what you need to do. Use DateValue() on the date field that you want to compare against Date()-1 and no need to include it in the query output.
It is only going to get harder from now on, so you may as well make the effort now, or take up something else?
Best try another hobby then?
You have been advised what you need to do. Use DateValue() on the date field that you want to compare against Date()-1 and no need to include it in the query output.
It is only going to get harder from now on, so you may as well make the effort now, or take up something else?
