Date Difference

[ekendricks]

Thanks a million for all the help so far !

What I'm trying to accomplish here is to show a link if the Todays date is equal to or not more that 10 days for the date the record was added. I have tried tons of combinations of +10, -10 etc and get a script error.

<%
If FormatDateTime(Date(), VbLongDate) =< FormatDateTime(DateAdded, VbLongDate) Then

response.write("Page Background")

Else
response.write "Page Background"

End if
%>

Thanks for all assistance

Ernest L. Kendricks

[Rob]

so... you want only to pick out those dates that are either today... or ten days from now?

[ekendricks]

The link "Page Background" is available to user to select a page background for their posting. When each record is added, the table field "DateAdded" is updated. What I'm wanting to do is give the user 10 days from the date they add the original record to either choose, update or change the page background. On day 11, the link would become inactive, preventing any further updates.

Thanks

ELK

[vor]

Try Using the Function DateDiff. It can tell you the time difference between 2 dates by either Days,Hours,Minues,seconds, etc.

Try something like.

Code: Select all

if DateDiff("d", Date(), "1/1/2000") < 11 then
   Response.Write "WooTWooT"
end if

Double check the Output values, Cause I might have the Date check in flipped. Oh Well.

Full Documentation at:
http://www.devguru.com/Technologies/.../datediff.html

Dont forget to check out VBScript Complete Reference at
http://www.devguru.com/Technologies/...ript_list.html

A LiNK you ShoULD always have on hand. (Also check out WSH Reference Section, Start Coding some of those Nasty email wormz :razz

[Rob]

I was gonna paste the MSDN description but the above is cool.