Striping a Date from a Date/Time Field

[Laura G]

How would you strip a date off of a date/time field?

I tried to use the datePart() function, but it will only
return one of the parts, not the entire date.

Any ideas would be helpful.

Thanks.

 

[Rick Brandt]

How would you strip a date off of a date/time field?

I tried to use the datePart() function, but it will only
return one of the parts, not the entire date.

Any ideas would be helpful.

DateValue()

Keep in mind that what this really does is change the time to midnight
(zero). A Date DataType always has a time element, but midnight can be
more easily ignored.