Date Question

[AGB]

Hi all,

I need a script that tells the user what the date is for monday and
what the date is for friday for the current week based on the current
day.

Any help?

 

[Aaron Bertrand [SQL Server MVP]]

Given a "standard" datefirst setting, e.g. Sunday = 1, Monday = 2, you can
try this:

<%
dt = date()

dw = datepart("w", dt)
response.write "Monday = " & (dt + (2-dw))
response.write "<br>"
response.write "Friday = " & (dt + (6-dw))
%>

Might make more sense to have a calendar table though.
http://www.aspfaq.com/2519

 

[AGB]

That works great, thanks