Thank you very much. It works perfectly. I made a copy of the database,
changed the DOB field to a Date/Time type and I didn't loose anything.
The search I'm using is:
WHERE
DOB <= #CreateODBCDate(DateAdd("yyyy", -Form.StartAge, Now ()))#
and
DOB >= #CreateODBCDate(DateAdd("yyyy", -Form.EndAge, Now ()))#
Works like a charge.
No I have to see if changing the DOB type to Date/Time broke anything else.
Thanks
Brian
At 02:06 PM 6/2/2002, you wrote:
>----- Original Message -----
>From: "Brian Simpson" <[EMAIL PROTECTED]>
>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?
>---------------------------
>
>Is there much data? I reckon you may well lose the current data, but
>I've never tried this. Make a copy of the database file and try it out!
>
>- 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
