Skip to main content
Question

Find most recent date in list of dates

  • September 26, 2022
  • 0 replies
  • 359 views

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 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,";")))

------------------------------
Anne Martin
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • September 27, 2022
It looks like a great formula.  What's the problem with it.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------