Date Default

[Nip Lewis]

Is there a way to have the Date default less one day or more in a Change field so when entering data the Add date field is not the same as the Change Date field. This happens when a new person is added and both the ADD DATE field and CHANGE Date Field are defaulted to Date(). Any help will be appreciated.

Nip
Lewis

[Tom Cone Jr]

RE: Date Default

Nip,

Many would do it this way:

For the ADD date field define a default value equal to date() and set skip to true, so user can never change it.

For the CHANGE date field define a calculated field value equal to Date(), so it is updated to the current date whenever a change occurs.

--tom

[Nip Lewis]

RE: Date Default

Hi Tom

I tried that, but it did not work. In the Voter List for the Town, I have 2 fields "Adddte"; and "Chgdt" I have set Addte to default at Date() and Chgdt as a calculated date as you suggested. When I add a new voter, the both fields record that days date; I just want to have the addte show and not the chgt date on adding a new voter. The reason I want this is that on the same date I add a voter, I may also may be changing something in a voter already in the database. I want to print two types of reports on the same days; i.e. a change report and an add report separately. I hope this is not too confusing.

Thanks for any more hints

Nip Lewis

[Stan Mathews]

RE: Date Default

So you only want the change_date to be filled in if the person has already been added. Following Tom's suggestion///

define a calculated field value equal to

case(isnotblank("add_date"),Date())

[Tom Cone Jr]

RE: Date Default

Nip,

Your requirements add a significant level of complexity.

I think maybe I'd add a time stamp field for both the Add transaction and for each Change transaction. I'd use both date and timestamp fields to filter the 'Changes' that happen to be initial 'Adds'.

-- tom

[Oran Hamilton]

RE: Date Default

Why not take the change date out of the table and create a seperate table with two fields, voter Id and change date? Attach a script to the onchange event to open the changed table and either change the latest change date or add another record if you want a history of changes?

Oran