Skip to main content
Question

Listing dates between start date and end date

  • August 18, 2020
  • 0 replies
  • 70 views

Is there a way I can list all the dates that are between a start and end date?

------------------------------
Josh Hamilton
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
try this formula
var date Start = Date(2020,8,18);
var date End = Date(2020,9,5);

List("\n",
ToText($Start),
If($Start + Days(1)<= $End, ToText($Start + Days(1))),
If($Start + Days(2)<= $End, ToText($Start + Days(2))),
If($Start + Days(3)<= $End, ToText($Start + Days(3)))
)

Replace the hard coded Start and End with the dates from your app.  Continue pattern for as long a range as your app needs to handle.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------