Thread: need to use floor() function in access
View Single Post
  #8 (permalink)  
Old 11-05-03, 17:12
DannyY DannyY is offline
Registered User
  
Join Date: Jul 2002
Location: Romania
Posts: 122
You don't need the Floor function.

You need:

Format([YourExpression], "mm/dd/yyyy")

Or

DateValue([YourExpression])


HTH
Reply With Quote