Modification Formula

[tonyA1DL]

I have a field called "tax point" which is populated with a date from another field called "function date" when boolean field "account customer" is set to "y"

Problem is sometimes we need to change the tax point to a date earlier than the function date. Whilst this can be manually overkeyed, the problem is it subsequently reverts to the calculated date if any other fields within the record are at any stage modified.

Using Creation formula instead isn't an ideal solution, as the "account customer" flag is not always set when the record is created, it is often set after the record is created.

Any ideas?

 

[paulbent]

You probably need to add another boolean field to flag if the calculation has been manually overridden and adjust the modification formula accordingly.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[tonyA1DL]

Paul

Thanks for you reply. How exactly would I do that though, bearing in mind the "tax point" field is not a calculation, simply a date field populated with a value equal to that in the "function date" field, which is refreshed whenever any of the other fields in the record are modified.

Thanks

Tony

 

[paulbent]

Flag is a boolean field with creation formula 1 = 0 so it defaults to False. When True, the modification formula for TaxPoint doesn't change its existing value:

If(Flag, TaxPoint, OtherDateField)

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[tonyA1DL]

many thanks Paul - another frustrating problem solved