Find most recent date in list of dates
I am trying to display the last pay date for each month. The formula querya returns a list of the pay dates in that month, but I am stuck on how to find the highest date in the list. //FID 8 = pay ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt looks like a great formula. What's the problem with it.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
It doesn't return any data, and I don't understand it well enough to break it down to find the glitch.
------------------------------
Anne Martin
------------------------------
------------------------------
Anne Martin
------------------------------
- is your app using dd-mm-yyyy as date format ?
------------------------------
Prashant Maheshwari
------------------------------- MarkShnier__YouAnne, I don't have time to test right now, but you can move us forward by making a new formula multi select text for field to just return the string.
//FID 8 = pay date
var text myquery= "{8.GTE.'"&[First of Month]&"'} AND {8.LTE.'"&[Last of Month]&"'}";
var text querya= "{GetFieldValues(GetRecords($myquery),8)}";
$querya
Let's see what the string looks like. I suspect that the dates are in an unexpected format.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- It returns the formula query now: {GetFieldValues(GetRecords($myquery),8)}
All my dates are in mm/dd/yyyy format.
------------------------------
Anne Martin
------------------------------
