i need a list box that inserts different dates in selection.upon insertion of the data, i will have a drop down box to ask the user how many days they want to display the advert.

this will be arranged in the drop down as : 3 days, 7 days, 10 days, 14 days

Now say if the user selects they want to advertise the ad for 3 days.

I want the date inserted in the database to be from 3 days from the current date!!!

hope this is making sense.

Can you help?

What scripting langauage are you using?

Have you tried using the DATEADD function?
www.w3schools.com/vbscript/func_dateadd.asp is a good place to start.
DateAdd(d,cmbDropDown,date) - something like that


Live the life you love
Love the life you live
~ ~ ~ ~ ~ ~ ~
<b>Simon Martin</b> - <i>DMXzone Manager</i>
<font size=1>[ Dreamweaver MX/MX2004 | ASP | SQL | XHTML/CSS | Web Accessibility ] </font id=size1>

Simon is right.....dateadd is the way to go

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]