Layout Issue with Dates

[JTSmith]

I have 2 fields, a Move In Date and Move Out Date. I need a report/layout that is a "Receipt", that takes those two dates (example January 1 and March 15) and then puts them on the receipt as:

January 1st, 2012

January 2nd, 2012

January 3rd, 2012

etc

etc

Until it gets to March 15.

Each line has a rental rate, and I need to put a total on there, but I can handle all that. It's the daily breakout that i'm struggling with.

Any advice? Thank you!

[comment]

A repeating calculation field could do that. Other options are a recursive custom function (requires the Advanced version to install) or a looping script to write it out, either to a field (return-separated) or to individual records in a related table.

[Agnes Riley]

You could also use the List function if they are in a separate table. If not, there's a function on briandunning.com that can list out data from the same field.

[No_access]

Try this

http://www.briandunning.com/cf/231

[JTSmith]

Try this

http://www.briandunning.com/cf/231

When I do this:

Let ( [

dateMin = GetAsDate ( Min ( GetAsDate ( Date Begin );

GetAsDate ( Date End ) ) );

dateMax = GetAsDate ( Max ( GetAsDate ( Date Begin );

GetAsDate ( Date End ) ) );

dateList = Case (

not IsValid ( dateMin ) ; "?";

not IsValid ( dateMax ) ; "?";

dateMin = dateMax ; dateMax & ¶;

dateMin & ¶ & DateValues ( dateMin + 1 ; dateMax )

);

result = dateList

];

result

)

It highlights a section and says "the function cannot be found." The highlighted part is this: "lues (dat"

It's on the line that says: dateMin & ¶ & DateValues ( dateMin + 1 ; dateMax )

If it matters, I'm using FM12.

[comment]

Other options are a recursive custom function (requires the Advanced version to install)

[JTSmith]

Ok wasn't 100% sure what a recursive function was... dang. Thanks for the help.

[eos]

Ok wasn't 100% sure what a recursive function was... dang. Thanks for the help.

If you post your file, I guess some helpful soul would be willing to input that Custom Function for you. (You can use CFs without Advanced, just not edit them.)