If you tell your database to default the field to "Now()" then it will be updated whenever a new record is inserted - OR when an existing record is updated, so long as you include the field name in your CFUPDATE or CFQUERY. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
- Re: date time problem Douglas L. Brown
- RE: date time problem Paul Wille
- Re: date time problem corrigan
- Re: date time problem Douglas L. Brown
- RE: date time problem C. Hatton Humphrey
- Re: date time problem Douglas L. Brown
- RE: date time problem Michael Wilson
- RE: date time problem Angel Stewart
- Re: date time problem corrigan
- Re: date time problem corrigan
- Re: date time problem Peter Tilbrook
- Re: date time problem Douglas L. Brown
- RE: date time problem Christopher Olive
- Re: date time problem Douglas L. Brown
- RE: date time problem Adkins, Randy
- RE: date time problem Adkins, Randy
- Re: date time problem Douglas L. Brown
- Re: date time problem corrigan