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
It 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
------------------------------- is your app using dd-mm-yyyy as date format ?
------------------------------
Prashant Maheshwari
------------------------------- Anne, 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
------------------------------
