Prev: Query: Calculating
Next: how to build expression with conditins and totals
From: GMC -LSND on 25 Feb 2010 16:03
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?



From: John Spencer on 25 Feb 2010 16:32
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

GMC -LSND wrote:
> 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?
>
>
>
From: GMC -LSND on 25 Feb 2010 16:40
Neither one of those are producing anything. The field comes out with
nothing in it.


From: GMC -LSND on 25 Feb 2010 16:43
NEVER MIND!!! Brain isn't working. Your coding works.


From: David W. Fenton on 26 Feb 2010 18:20
"GMC -LSND" <gcoleman(a)legalassistfake.org> wrote in
news:eE1zEOmtKHA.4220(a)TK2MSFTNGP05.phx.gbl:

> NEVER MIND!!! Brain isn't working. Your coding works.

I hate it when the brain isn't working.

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

Forehead, too. ;)

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 | 
Pages: 1
Prev: Query: Calculating
Next: how to build expression with conditins and totals