Dates

[Dale and Sandi Brown]

Is there a way to get just the mm/dd/yyyy in a query from a date/time field
to compare to a forms date without using the format function?

 

[Duane Hookom]

You can use the DateValue() function:
DateOnly: DateValue([YourDateTimeField])