URGENT date help

Report · Jul 30, 2006

Dear all

using ASP and MS ACCESS

i have a column called strAddDate

I want to provide 3 link to my users

Link 1 - When clicked updates the strAddDate column with 10 days

Link 2 - When clicked updates the strAddDate column with 20days

Link 3 - When clicked updates the strAddDate column with 30days

How can I do this ?

thanks in advnace

Report · Jul 31, 2006

Use a DateAdd function. eg.DateAdd(d, 10, strAddDate) - DateAdd(d, 20,
strAddDate) - DateAdd(d, 30, strAddDate).

"Techy" <anwar@clickbahrain.com> wrote in message
news:eak0ut$1um$1@forums.macromedia.com...
> Dear all
>
> using ASP and MS ACCESS
>
> i have a column called strAddDate
>
> I want to provide 3 link to my users
>
> Link 1 - When clicked updates the strAddDate column with 10 days
>
> Link 2 - When clicked updates the strAddDate column with 20days
>
> Link 3 - When clicked updates the strAddDate column with 30days
>
> How can I do this ?
>
> thanks in advnace
>
>
>
>