Help with a formula query, please
I'm having trouble with a formula query. I can't get the output to match what I expect. Right now, all I want is the field to give a list of all my records that have a User Input Date on or before the...
Forum Discussion
Well, after a lot more testing, I think I figured out part of the problem above. The text version of today's date, despite my app and profile set to use DDMMYYYY works as the rest of the equations do when I write it out in MMDDYYYY format. I still don't think the queries are working as expected, however, and in fact are giving very unexpected results. To that end, I opened a case with support. So far they agreed that their results are not the same as mine and they are going to check out my app. Thanks for considering.
------------------------------
David Halter
------------------------------
------------------------------
David Halter
------------------------------
- What irritates me the most is , formula query field names are not updated in formula like rest of QuickBase , so if you rename a field your formula query will stop working. I have gone back to creating child parent relationship to have stability.
------------------------------
Prashant Maheshwari
------------------------------- MarkShnier__You
Qrew Legend
@Prashant Maheshwari
I tried renaming a field which was used in a formula query and as I expected, the formula automatically updated to the new field name. Can you explain further as to your perception of the problem?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- One Problem I did find in formula query is for lookup it asks for FID in correct case - 6 and not variable , if I delete this particular field (i've done so by mistake being a n00b , there is no error showcased in formula, on other hand if formula query .
GetRecords("{pmcode.EX.'"&$pid&"'}","field"),6
------------------------------
Prashant Maheshwari
------------------------------
