Date Formula as a Reference
Hello! I am trying to automatically relate records in a child table to a parent table based on the month that they are marked as "Complete". I have the date that they are marked complete in a fi...
Forum Discussion
I had a similar problem with a formula that returns a number. For me it was a false positive error. When I ran a report on that table the formula appeared to calculate correctly. I continued to test and it works fine. I put in a help desk request, but it closed as the formula worked.
------------------------------
Richard Chagnon
Northwestern University
Chicago IL
------------------------------
You are quite right. It looks like I just needed to save it and it would work. I suppose I was a under the assumption that I couldn't save it, because generally a formula field will stop you from saving if you aren't returning a value of the correct type.
So now everything works beautifully.
QB Really should fix this though. It's a bit confusing.
Thanks!
------------------------------
Sterling Long
------------------------------
So now everything works beautifully.
QB Really should fix this though. It's a bit confusing.
Thanks!
------------------------------
Sterling Long
------------------------------