note sure of the syntax exactly.
date(year(date) + (month(date)=12), mod(month(date),12)+1,1)
From: "Timothy C. Hill" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: I want my #$# on the first of the month.
Date: Wed, 31 May 2000 16:32:45 -0400
I have been on a 23 hour coding spree to finish up a project. How do
you create an odbc date value for the first of next month? I thought
i had it but something is escaping me. I am tired and this is the
last thing.
thanks
Tim Hill
-- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.