Query date field with date & time

[netrusher]

When querying for data and the date fields have Date & Time is there a way to ignore the time and have the
query just find info based on the date and not the time?

 

[genomon]

Check out DatePart in Access help.

Alcohol and calculus don't mix, so don't drink and derive.

 

[HarleyQuinn]

One way is to use the FORMAT() function on the field.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[netrusher]

I have been searching and cannot find an example of what
you mean. Please show me an example if you can!

 

[HarleyQuinn]

For Format, a simple example is:

Format([mydate], "yyyymmdd")

Hope that helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[netrusher]

HarleyQuinn,

Thanks for your help. I am using the GuardTime Field to query
for a date such as 12/10/07.

How and where do I use your example in the query?

Where is currently in the field is 12/10/2007 01:26:37 PM

I only want to query on the 12/10/2007 part.

 

[SkipVought]

Date/Time values are NUMBERS. The DATE is the integral part of the number and the TIME is the fractional part.

Dim dTheDate as Date, sTheDate as string
dTheDate = CLng([GuardTime])
sTheDate = Format([GuardTime],"yyyy/mm/dd")

NOTE: the Format function returns a STRING representation of the date and NOT a REAL DATE value.


Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}