Trim Time off Date

  • Thread starter Thread starter GMC -LSND
  • Start date Start date
G

GMC -LSND

Access 2007 linked to SQL 2008 database

I have a query with a date field that has the time included on it. How do I
trim, truncate, remove the time part of the date in the query field named
cndate?
 
I might use an expression like the following:

IIF(IsDate(cnDate),DateValue(cnDate),Null)

Or perhaps a bit faster
IIF(CNDate is Not null, DateValue(cnDate),Null)



John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
NEVER MIND!!! Brain isn't working. Your coding works.
Click to expand...

I hate it when the brain isn't working.

I've found a good slap up-side the head seems to help.

Forehead, too. ;)
 
Back
Top