Striping a Date from a Date/Time Field

  • Thread starter Thread starter Laura G
  • Start date Start date
L

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.
 
Laura G said:
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.
Click to expand...

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.
 
Back
Top