Creating a calculated date field but needs to be editable

Question

Greetings,I would like to create a calculated date field, but I need to have that field editable if the date needs to be changed.  Is there a way to go about doing this?  Any help would be greatly appreciated.Thank you.------------------------------John Sanchez------------------------------

MarkShnierYou · Answer

The usual way to do this is to have a calculated field which also accepts the input of a separate override field in its calculation. The override field would only be shown on the form in Edit / Add modes.

IF(not IsNull(Date Override]), [Date Override], ... calculation goes here)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community