Zydeceltico
Registered User.
- Local time
- Today, 09:29
- Joined
- Dec 5, 2017
- Messages
- 843
Hi all -
I record both Date and Time in the same field like this: 5/3/2019 2:31:27 PM.
I want to build a query that will let me look at all of the records from some other day - a single day.
I tried this code that clearly isn't correct as it returns nothing even though I have data on this date:
What do I need to do to parse out just the date?
Thanks!
Tim
I record both Date and Time in the same field like this: 5/3/2019 2:31:27 PM.
I want to build a query that will let me look at all of the records from some other day - a single day.
I tried this code that clearly isn't correct as it returns nothing even though I have data on this date:
Code:
SELECT lutblinspectiontypes.inspectiontype,
tblinspectionevent.datetime,
[jobnumber] & [task] & [resource] AS Job
FROM tbljobs
INNER JOIN (lutblinspectiontypes
INNER JOIN tblinspectionevent
ON lutblinspectiontypes.inspectiontype_id =
tblinspectionevent.inspectiontype_fk)
ON tbljobs.job_id = tblinspectionevent.job_fk
WHERE (( ( tblinspectionevent.datetime ) = [enter date:] ));
What do I need to do to parse out just the date?
Thanks!
Tim