Date Difference

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

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

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

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

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

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

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder