David
|
| Posted: 10/28/2004, 11:19 AM |
|
I want to add a page to my application that will allow users to enter a date a policy was reviewed, then select a review cycle for that policy (ie. 1 year, 2 years) and then have the page calculate the next review date that will be stored in a field within the policy table. I have played around with it and I can't seem to make any headway.
Any ideas on the best way to accomplish this would be greatly appreciated. The more detailed the response the more appreciated 
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 10/28/2004, 4:08 PM |
|
On your page create a hidden field for the new "next review date" database field, then calculate the new value in the Before Insert event, for example:
Form.Control3.Value = function(Form.Control1.Value, Form.Control2.Value)
This is as much detail as I can provide without implementing the whole thing myself, or understanding what exactly doesn't work in your case.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
DonB
|
| Posted: 10/28/2004, 7:28 PM |
|
It may be reasonable to define a Custom Update (and Insert?) for the data
source. Add the "next review date" to the list of updated/inserted columns,
set it to an "Expression" type and upt in the appropriate "date add"
function (since this is an ASP forum, that probably means
DateAdd("y",2,reviewdate) or something similar to that.
--
DonB
http://www.gotodon.com/ccbth
"peterr" <peterr@forum.codecharge> wrote in message
news:641817be2f24b5@news.codecharge.com...
> On your page create a hidden field for the new "next review date" database
> field, then calculate the new value in the Before Insert event, for
example:
> Form.Control3.Value = function(Form.Control1.Value, Form.Control2.Value)
> This is as much detail as I can provide without implementing the whole
thing
> myself, or understanding what exactly doesn't work in your case.
> _________________
> Peter R.
> YesSoftware Support Representative
> http://support.codecharge.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
David
|
| Posted: 10/29/2004, 6:14 AM |
|
There is no doubt about it, this software is great but the real value is this forum. Thanks Peterr and DonB for you time. I got it to work perfectly.
|
|
|
|
|
