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 returns the formula query now: {GetFieldValues(GetRecords($myquery),8)}
All my dates are in mm/dd/yyyy format.
------------------------------
Anne Martin
------------------------------
All my dates are in mm/dd/yyyy format.
------------------------------
Anne Martin
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendcan you post a screen shot of what the string looks like?
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
------------------------------
Anne Martin
------------------------------- MarkShnier__You:) no wonder why it's not working.
Change both your formulas to remove the outer quotes and the curly brackets..
//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
and maybe the full form,ula will work thius way.
//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);
Max(
ToDate(Part(ToText($querya),1,";")),
ToDate(Part(ToText($querya),2,";")),
ToDate(Part(ToText($querya),3,";")),
ToDate(Part(ToText($querya),4,";")))
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------- Wonderful! That worked!
I didn't realize the quotes and curly brackets were because of the formula query, and thought they were needed for the variable.
Thanks!
------------------------------
Anne Martin
------------------------------