From memory.......
CreateODBCDate( CreateDate(Year(Now(), Month(DateAdd("m", 1, Now())), 1))
At 16:32 31/05/00 -0400, you wrote:
>
>
>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?sidebarsts&bodysts/cf_talk or send
>a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
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.