Tauqeer
|
Posted: 04/13/2004, 4:25 AM |
|
Hi,
I have a problem. i have field which contains no of days i.e. integer value and the another field is the date field.Now i want whenever user change the date field it add the no of days in the date and show in the other field.
Please tell me which function i used to add the date.
Thanks in advance.
|
|
|
DonB
|
Posted: 04/13/2004, 11:56 AM |
|
Use the DateAdd() function:
tomorrow = DateAdd('d',1,Now)
a_year_ago = DateAdd('yyyy',-1,Now)
--
DonB
http://www.gotodon.com/ccbth
"Tauqeer" <Tauqeer@forum.codecharge> wrote in message
news:6407bce0e1091e@news.codecharge.com...
> Hi,
> I have a problem. i have field which contains no of days i.e. integer
value
> and the another field is the date field.Now i want whenever user change
the
> date field it add the no of days in the date and show in the other field.
> Please tell me which function i used to add the date.
> Thanks in advance.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
peterr
Posts: 5971
|
Posted: 04/13/2004, 12:31 PM |
|
It look like you want to do this in real-time, meaning that the calculation would be done within the browser (client), which would require using JavaScript. I recommend finding some JavaScript function(s) that can add days to dates, for example: http://www.google.com/search?q=javascript+add+days+date
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|