> I have a field which contains the date and time of the entry. How do I
> extract the date portion from it? I do not want the time, just the
> date only.

cast(mydatetime as date)

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/