Re: I want my #$# on the first of the month.

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

Re: I want my #$# on the first of the month.

Find the current month, create a date for the first of this month, then add one month to that date. #CreateODBCDate(DateAdd("m", 1, CreateDate(Year(Now()), DatePart("m", Now()), 1)))# Jim -Original Message- From: Timothy C. Hill [EMAIL PROTECTED] To: [EMAIL PROTECTED]

RE: I want my #$# on the first of the month.

I am not guru - but try this - cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput hope that does the trick. Elizabeth -Original Message- From: Timothy C. Hill [mailto:[EMAIL

RE: I want my #$# on the first of the month.

I am not guru - but try this - cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput hope that does the trick. Elizabeth -Original Message- From: Timothy C. Hill [mailto:[EMAIL

Re: I want my #$# on the first of the month.

Tim, jeez, I hope you figured this out by now but if not... cfset thismonth = Now() cfset nextmonth = DateAdd("m", 1, thismonth) cfset NMyear = DatePart("", nextmonth) cfset NMmonth = DatePart("m", nextmonth) cfset NMday = 1 cfset finalval = CreateODBCDate(CreateDate(NMyear, NMmonth,

Re: I want my #$# on the first of the month.

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

Re: I want my #$# on the first of the month.

Not very elegant, but here it is... cfset new_date = #CreateODBCDate(Evaluate(Month(Now())+1)'/1/'Year(Now()))# Currently outputs: {d '2000-06-01'} Good luck. Judah At 04:32 PM 5/31/00 -0400, Timothy C. Hill wrote: I have been on a 23 hour coding spree to finish up a project. How do you

RE: I want my #$# on the first of the month.

I love threads like this, always interesting to see what people come up with. Just wanted to correct this one (and at least one other person that did something similar). cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)#

Re: I want my #$# on the first of the month.

cfset current = #month(now())# cfset next = #current# + 1 cfset thedate = #createdate(#year(now())#, #next#, 01)# cfoutput#createodbcdate(thedate)#/cfoutput You can't just add 1 to the current month...what happens when it is December? You do indeed need to use the DateAdd function to do

RE: I want my #$# on the first of the month.

Or you could try this, maybe I'm crazy just seems easier FirstDayOfMonth( date). Love the old 4.0 documentation, bookmarks anyone remember those, is Allaire ever gonna give em back in the 4.5 documentation. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From:

Re: I want my #$# on the first of the month.

Oh Geez! hee hee hee You're right..FirstDayOfMonth IS a function. ;-P Anyways..the code examples were nice all the same I guess ;-P -Gel - Original Message - From: Robert Everland [EMAIL PROTECTED] Or you could try this, maybe I'm crazy just seems easier FirstDayOfMonth( date).

I want my #$# on the first of the month.

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

I want my $ on the first of the month

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 -- Timothy C. Hill, [EMAIL PROTECTED] on 05/31/2000