Date function

[Sharad Gupta]

Friends

I need a date simple date function that would append the coming month
value in my current month

like
monthname(month(date)) : gives me current month in string
i need next month , a string value added to it.
The problem I am facing is this..
prevmon = monthname(month(date) + 1)
this is last month of the year, and when I append 1 to this function,
it gives error since dec is the last month of the year. It is not
appending itself to Jan2005.
It works fine for getting the string value for last month iei
prevmon = monthname(month(date) - 1)

Pls help

[Bob Barrows [MVP]]

Sharad Gupta wrote:

Friends

I need a date simple date function that would append the coming month
value in my current month

like
monthname(month(date)) : gives me current month in string
i need next month , a string value added to it.
The problem I am facing is this..
prevmon = monthname(month(date) + 1)
this is last month of the year, and when I append 1 to this function,
it gives error since dec is the last month of the year. It is not
appending itself to Jan2005.
It works fine for getting the string value for last month iei
prevmon = monthname(month(date) - 1)

Pls help

monthname(month(dateadd("mm",1,date)))

Look up the dateadd function in the vbscript documentation. If you don't
have the documentation, you can download it from here:
http://www.microsoft.com/downloads/d...DisplayLang=en

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray Costanzo [MVP]]

So, if it's December, you want January, correct?

Function NextMonthName(d)
dOneMonthFromD = DateAdd("m", 1, d)
dNextMonth = Month(dOneMonthFromD)
NextMonthName = Monthname(dNextMonth)
End Function

Or the abbreviated version:

Monthname(Month(DateAdd("m", 1, yourDate)))

Ray at work
"Sharad Gupta" <g_******@yahoo.com> wrote in message
news:7e**************************@posting.google.c om...

Friends

I need a date simple date function that would append the coming month
value in my current month

like
monthname(month(date)) : gives me current month in string
i need next month , a string value added to it.
The problem I am facing is this..
prevmon = monthname(month(date) + 1)
this is last month of the year, and when I append 1 to this function,
it gives error since dec is the last month of the year. It is not
appending itself to Jan2005.
It works fine for getting the string value for last month iei
prevmon = monthname(month(date) - 1)

Pls help

[Sharad Gupta]

Thanks a lot ray

Monthname(Month(DateAdd("m", 1, yourDate))) :
it solved my problem

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!