Date only from a Access Database 1

[scottydd]

I'm trying to figure out how to convert a DATE/TIME field in Access to just a Date using a select statement. Any help would be appreciated.

 

[other3]

What is the format of the Date/Time field?

Everything I know I learned from The Grateful Dead and Buffy The Vampire Slayer
Charlie

 

[jzelhart]

SELECT tbl.Last_Activity_Date, Format([Last_Activity_Date],'m/d/yyyy') AS DateOnly
FROM tbl;

Format is a function in Access that can convert the date to a different format.

Hope this helps.

Hope everyone is having a great day!

Thanks - Jennifer

 

[scottydd]

Thanks Jennifer works great.

 

[BoulderBum]

Often, this is done by using format strings on the business layer (to take the processing load off of the database server).

Certain controls, like the DataGrid, have the format string handling functionality built in (via the Data formatting expression), and the .ToString() method accepts a format string as an optional argument.

See here:

http://msdn.microsoft.com/library/d...e/html/cpconstandarddatetimeformatstrings.asp