Skip to main content
Inspiring
July 31, 2006
Question

URGENT date help

  • July 31, 2006
  • 1 reply
  • 241 views
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




This topic has been closed for replies.

1 reply

Inspiring
July 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
>
>
>
>