CreateODBCDateTime(
CreateDate(
Year( Now() ),
Month( FORM_VALUE_GOES_HERE ),
Day( Now() )
)
)
......................
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 27, 2006 1:02 PM
To: CF-Talk
Subject: Simple Date - I think
All,
I'm doing an insert from a form.
1) In the form the months of the year are listed.
2) Each month having it's appropriate value, January is 01, February is
02 etc.
3) Now when I do my insert statement, I want to insert an ODBCDateTime
using #CreateODBCDateTime(now())# but I want to change the month's value
before inserting.
Any ideas how to do this?
Note: I was thinking of inserting a string for month and a string for
the year, but I like the flexibility ODBCDateTime stamp gives for
reporting.
Thanks.
D
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261757
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
