>You're right..FirstDayOfMonth IS a function.
Don't get TOO excited, I'm not sure it's the function you would want to
use. FirstDayOfMonth returns the actual day of the year that the first day
of the particular month falls on. For instance, for June, it would be
something like 152.
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).
From: Judah McAuley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 31, 2000 11:44 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: I want my #$# on the first of the month.
Not very elegant, but here it is...
Currently outputs: {d '2000-06-01'}
Good luck.
Judah
At 04:32 P
> >
> >
> >
> >#createodbcdate(thedate)#
>
> 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 something
> like this.
You don't NEED to use DateAdd, but it makes the code shorter.
You COULD use something like th
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).
>
>
>
>#createodbcdate(thedate)#
You can't just add 1 to the current month...what happens when it is
December? You do indee
Not very elegant, but here it is...
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 create an odbc date value for the first of next month? I thought
>i had it
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:4
Tim,
jeez, I hope you figured this out by now but if not...
This may be the long way to do this - and will hopefully be
self-explanatory. I would probably do some sort of ugly
functionwithina(functionwithina(function))) kinda thing in real
life. Don't know if that's a good thing t
I am not guru - but try this -
#createodbcdate(thedate)#
hope that does the trick.
Elizabeth
-Original Message-
From: Timothy C. Hill [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 31, 2000 1:33 PM
To: [EMAIL PROTECTED]
Subject: I want my #$# on the first of the month.
I have
I am not guru - but try this -
#createodbcdate(thedate)#
hope that does the trick.
Elizabeth
-Original Message-
From: Timothy C. Hill [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 31, 2000 1:33 PM
To: [EMAIL PROTECTED]
Subject: I want my #$# on the first of the month.
I have
]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, May 31, 2000 8:11 PM
Subject: 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 some
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 someth
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
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
-
14 matches
Mail list logo