On 2/1/01, Mark Smeets penned:
><CFSET EDate = EMonth + EDay + EYear + #CreateODBCTime(Now())#>
I'm not sure where the Time(Now()) comes into play. But here are
several options:
To create a time stamp with the date chosen from the menus but at the
exact time of day as when chosen:
<cfset EDate = createdatetime(EYear, EMonth, EDay, hour(now()),
minute(now()), second(now()))>
To make the time a specific time, we'll use 1:10:30 PM
<cfset EDate = createdatetime(EYear, EMonth, EDay, 13, 10, 30)>
Or midnight:
<cfset EDate = createdatetime(EYear, EMonth, EDay, 00, 00, 00)>
Then insert into your database as:
#CreateODBCDateTime(EDate)#
For the latter you could really just use:
<cfset EDate = createdate(EYear, EMonth, EDay)>
#CreateODBCDate(EDate)#
Which will default to midnight.
Midnight is actually the beginning of the day, or 00:00:00, not how
we typically think of it as the end of the day. :)
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
