Solved

DATEADD() Function To Find Closest Day Of Week, One Month Later.

Posted on 2004-08-05
9
891 Views
Last Modified: 2012-08-13
Hey Experts,

I have a date challenge.  I'm writing an ASP application that uses dateadd() to get the date of the next month and that is fine.  I use this:

nextmonth = dateadd("m",1,date)

My issue is that I need the nextmonth value to be on the same day of the week as the starting date, for example, today is Thursday, 8/5/2004, the above function returns Saturday, 9/5/2004.  I really need to calculate the closest Thursday to the nextmonth value which would be 9/2/2004.

I hope that someone has solved this issue and can be of help.

Thanks,
Glen
0
Comment
Question by:glenwr
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 14

Expert Comment

by:_Stilgar_
ID: 11725122
why not adding 4 weeks?

nextmonth = dateadd("d",28,date)
0
 
LVL 22

Accepted Solution

by:
neeraj523 earned 250 total points
ID: 11725210
Hello

Try this

======================================================
<%
currDate = "05-Aug-04"
currDay = WeekDay(currDate)

nextDate = DateAdd("m",1,currDate)
nextDay = WeekDay(nextDate)


if nextDay >= currDay Then
      nextDate = DateAdd("d",-(nextDay-currDay),nextDate)
Else
      nextDate = DateAdd("d",(currDay-nextDay),nextDate)
End if
%>
=====================================================

neeraj523
0
 
LVL 58

Expert Comment

by:Gary
ID: 11725221
That will work for 4 week months but what about 5 week months?

<%
datetocheck=date
response.write getFriday(datetocheck,weekday(datetocheck))

function getFriday(strdate,daytofind)
   olddate=dateadd("m",1,strdate)
   tmpdate= year(olddate) & "/" & month(olddate) & "/" & "1"
   for count=1 to 7
      tmpdate=dateadd("d",-count,tmpdate)
      if daytofind=weekday(tmpdate) then exit for
   next
   getFriday=formatdatetime(tmpdate,1)
end function
%>
0
 

Author Comment

by:glenwr
ID: 11725292
You are right Gary.

I have been using:

nextmonth = dateadd("ww",4,date)

The application is working with the recurrence patterns in the Outlook Calendar.  I'm not sure that each monthly recurrence is exactly 4 weeks apart.  For example, if an appointment is booked on the 5th Thursday of a month (which can happen), then if the next month only has 4 Thursdays, will Outlook book the appointment on the 4th Thursday on next month?

Let me test the solutions.  You guys rock!
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:glenwr
ID: 11725847
OK Guys,

I've tested the code snipets that were posted.  When I bounce the results against the Outlook calendar, what I really need to do is find the nth occurence of the date/day in the next month.  For example, today is the first Thursday of August, the next date I will need is the first Thursday in September, this can be done with dateadd("ww",4,date)
.  But, in the case where my starting date is the fifth Thursday of a month, I will need the last Thursday of the next month, if there are less than 5 Thursdays.

Now that I have enough information to be specific, any ideas?

Thanks Again
0
 
LVL 6

Expert Comment

by:Mike_Metro
ID: 11727153
Try this out

Function DayOccurence(dteDate)
  Dim intN

  intN = int(day(dtedate) / 7) + 1

  Select Case intN
    Case 1
        DayOccurence = "First"
    Case 2
        DayOccurence = "Second"
    Case 3
        DayOccurence = "Third"
    Case 4
        DayOccurence = "Fourth"
    Case 5
        DayOccurence = "Fifth"

  End Select
End Function
0
 
LVL 6

Expert Comment

by:Mike_Metro
ID: 11727169
Sorry didn't read the whole question.
0
 
LVL 6

Expert Comment

by:Mike_Metro
ID: 11730860
Try this one.

Dim dteStart, isLastWeek, intWeekNo, intNextMonth

dteStart = date()
intNextMonth = dateadd("mm",1 ,dteStart)
intWeekNo = int(day(dteStart) / 7) + 1
dteEnd =   dateadd("ww",intWeekNo ,dteStart)

DO WHILE month(dteEnd) <> intNextMonth
  dteEnd = dateadd("ww",-1,dteEnd)
LOOP
0
 
LVL 22

Expert Comment

by:neeraj523
ID: 11732886
Hello @glenwr

Have you tested my post ?? if yes.. what output u got ??

neeraj523
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Creating TABS in ASP Classic NOT using DIV 22 63
Css expand Div to fit its content (Of other divs) 4 46
Summernote required 3 101
ASP Button to clear text 4 44
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now