Displaying next sunday's date

[J. Muenchbourg]

Looking thru my resources, I cannot find a simple way of displaying next
sunday's date depending on what todays date is. I'd like to do it
without doing 7 if statements or case select:

todaysdate = now
sundaysdate = weekday(todaysdate + ?)

??
muench

 

[Aaron Bertrand - MVP]

<%
nextSunday = dateadd("d", 8-datepart("w", date()), date())
response.write nextSunday
response.write "<p>"
response.write formatdatetime(nextSunday, 1)
%>