I just had a look, The Access field type is TEXT. can I just change it to
time/date and be ok? or will I loose all the data that's in that field?
Thanks for your help.
Brian
At 01:53 PM 6/2/2002, you wrote:
>----- Original Message -----
>From: "Brian Simpson" <[EMAIL PROTECTED]>
>--snip--
><CFQUERY NAME="GetProfiles" DATASOURCE="#datasource#">
>SELECT ItemId, ImageA, FirstName, DOB
>FROM Profiles
>WHERE DOB < '#dateformat(Startage, "mm/dd/yyyy")#'
></CFQUERY>
>--snip--
>----------------------------
>
>This filter should return all records where DOB is over 20 years ago:
>
>WHERE DOB < #CreateODBCDate(DateAdd("yyyy", -20, Now ()))#
>
>Always use the CreateODBCDate function when adding to or comparing with
>database date/time fields. That's assuming you're using a date/time
>field and an ODBC database of course!
>
>HTH,
>
>- Gyrus
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>- [EMAIL PROTECTED]
>work: http://www.tengai.co.uk
>play: http://www.norlonto.net
>- PGP key available
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
