Calculating one control’s value derived from another control’s value

[jlathem]

I have a form to create a new record entry. In this form the user will enter a bank’s Transaction Date into a control called CR_Transaction_Date.

I have a hidden control called CR_SLA_Date that I want to calculate a value for a SLA Date derived from the CR_Transaction_Date plus 30 days.

Normally I would calculate the SLA date after the record is created and the CR_Transaction_Date was put into the DB but I need the date for specific reports to run quickly.

I tried several things but can’t seem to get it to work.
In the CR_SLA_Date Default Value

=CDate(Date()+30)
Gives me 30 days from the date the user creates the record.

=CDate(Date(Me. CR_Transaction_Date)+30)
Gives me nothing in the CR_SLA_Date field.

Can anyone offer suggestions?

Thanks,
James

 

[gemma-the-husky]

if the CR_SLA_date is ALWAYS 30 days after the tran date, then dont store it.

if you need to refer to the date, just use

trandate+30

-----------
assuming the second date is a "due date", there will be no discernable speed difference incurred by doing this calculation "on the fly"

 

[jlathem]

if the CR_SLA_date is ALWAYS 30 days after the tran date, then dont store it.

if you need to refer to the date, just use

trandate+30

-----------
assuming the second date is a "due date", there will be no discernable speed difference incurred by doing this calculation "on the fly"

Unfortunately all our accounts are not 30 days. Some have an SLA date of 20 days so I built 2 forms to enter the correct SLA date into the database.

I am also concerned when I start running some reports that have to filter records by number of days under and over the SLA date.

The state of Georgia wants the reports to run very quickly.

 

[jlathem]

I got it worked out.

Thanks guys!

James