Calculate & Auto Fill a Date Field
Hi Everyone, I have a form that when a particular date field is populated, I would like to add 15 days to that date and auto fill another date field. I created at Date formula with the following ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe only other possibility is that when you view the formula field setting and save, it has an error.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The field is on the form and I'm not getting any errors with the formula when I save the field. I've attached a document that shows the field configuration and formula, a copy of a report which I use for testing, and the two fields off the form where the "Proposal Approval to Alight" field is filled in but the "CR Proposal Due Date" is still blank. Hopefully, with this information you"ll be able is see my error.
------------------------------
Terri Wells
------------------------------
------------------------------
Terri Wells
------------------------------
- I found the problem! I have two fields that the names are very similar, and I grabbed the wrong. Problem solved; thing work great when you grab the correct field.
Thank you for your help and patience!
------------------------------
Terri Wells
------------------------------ - MarkShnier__YouI think that there is come confusion over the duplicate field names. The field name used in the formula is not the same as the field name on your report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - The field name on the report is just an alternate label text. See below:
------------------------------
Terri Wells
------------------------------