 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2006Remove time stamp
Hello, In my query I have a field called Rec'd date it has a date and time stamp. How can I show only the date but not the time in my query. Any help will be appreciated. Thank you in advance. Dear Alex: See the DateValue() function for this purpose. Just use DateValue(YourColumnName). Tom Ellison > Hello, > > In my query I have a field called Rec'd date it has a date and time stamp. > How can I show only the date but not the time in my query. Any help will > be > appreciated. Thank you in advance. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.