try dateadd("m",1,"#now()#")
or if you're using oracle
SELECT ADD_MONTHS(SYSDATE,1) FROM dual
On Mon, 16 Aug 2004 14:37:50 -0400, dave <[EMAIL PROTECTED]> wrote:
> probably need too be more specific.
> im assuming that u could just use something like
> WHERE date = date GTE #now()#
>
>
> ---------- Original Message ----------------------------------
> From: daniel kessler <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Mon, 16 Aug 2004 14:24:20 -0400
>
> >I am retrieving events for an events calendar from Now() forward. I want to output them per month, so I put in a loop that compares their month. If they're of the same month, then it outputs the info and then I want to update the current row. This doesn't seem to be working for me, among other things. I thought I remembered reading up on this but don't see it in the archives.
> >
> >Is there a way to update the current row?
> >
> >I guess I can group them to the month, but haven't looked into that yet.
> >
> >thanks.
> >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
