Daily Job List Query - Current Date Issue

[iProRyan]

Hi Guys,



Got another problem with a query, this time the query will be used to produce a report of all the jobs with the current date in the JobDate field, but having some problems filtering this in the query. I have added all the fields from tblJobs to the query and tried all sorts in the criteria for the JobDate field. The dates are selected from Calendar Picker and stored in the format DD/MM/YYYY can anybody help me?

The SQL for the query is:

SELECT tblJobs.[JobID], tblJobs.[CustomerID], tblJobs.[JobType], tblJobs.[JobDate], tblJobs.[JobStartTime], tblJobs.[JobEndTime], tblJobs.[JobNotes], tblJobs.[Completed], tblJobs.[Paid]
FROM tblJobs
WHERE (((tblJobs.[JobID])=Date()));

Any thoughts are appreciated!

Ryan

[June7]

Review http://allenbrowne.com/ser-36.html

[iProRyan]

I have read through this, but don't see exactly how this will help me, because I am not selecting data, I am search it, unless you can explain?

[orange]

Ryan,

SELECT tblJobs.[JobID], tblJobs.[CustomerID], tblJobs.[JobType], tblJobs.[JobDate], tblJobs.[JobStartTime], tblJobs.[JobEndTime], tblJobs.[JobNotes], tblJobs.[Completed], tblJobs.[Paid]
FROM tblJobs
WHERE (((tblJobs.[JobID])=Date()));

You have JobId =Date()

try JobDate =Date()

[June7]

The article discusses use of non-MS standard date values and the issues that can result. You need to be aware of that because you said your date is ddmmyyyy instead of mmddyyyy. In reality, Access stores dates as a double number that represents mmddyyyy, regardless of local display settings.

[iProRyan]

Thank you orange! Luckily someone is on the ball haha! How stupid, apologies for the silliest post ever! I'll try to be less clumsy in future, works perfectly now haha!

Thank you June7 dates are such an inconvenience with different formats especially in SQL servers haha!