Re: F45, how to query a date(time) column with just the date?

Andy Hardy wrote:
>
> In article <377CD576.C8A60CD_at_itacs.strath.ac.uk>, Mungo Henning
> <mungoh_at_itacs.strath.ac.uk> writes
> >If you try the function "trunc" (truncate) on a date methinks it throws
> >away the
> >time element, hence in the WHERE clause you can compare a truncated
> >record from the table with what the user has typed in.
>
> True, but it's not something you can do with the standard 'ENTER_QUERY',
> 'EXECUTE_QUERY' forms functionality i.e. when you use them, there's no
> WHERE/DEFAULT_WHERE clause to set.
>
> Andy
> >HTH
> >
> >Mungo
> >--
> >Mungo Henning - it's a daft name but it goes with the face...
> >mungoh_at_itacs.strath.ac.uk.http://www.itacs.strath.ac.uk/
> >(since everyone else does it) I speak for me, not my employer.
> >
> >
>
> --
> Andy Hardy. PGP key available on request
> ===============================================================

Yes - but you can trap the query using pre-query and use set_block_property to build your own where clause based on the date they enter ...

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."