Hello,

Would it be possible to create a script that would create 7 new
records, each dated sequentially? In other words, a new week's worth.
1/1/05, 1/2/05, etc?

Thanks for any ideas.

Al

al.rainey (AT) gmail (DOT) com wrote:
In its most obvious form:

Set Field [ gFirstDate, Date(1, 1, 2005) ]
New Record/Request
Set Field [ Date, gFirstDate ]
New Record/Request
Set Field [ Date, gFirstDate+1 ]
New Record/Request
Set Field [ Date, gFirstDate+2 ]
New Record/Request
Set Field [ Date, gFirstDate+3 ]
New Record/Request
Set Field [ Date, gFirstDate+4 ]
New Record/Request
Set Field [ Date, gFirstDate+5 ]
New Record/Request
Set Field [ Date, gFirstDate+6 ]


Or in its shortest form:

Set Field [ gFirstDate, Date(1, 1, 2005) ]
Set Field [ gCounter, 0 ]
Loop
New Record/Request
Set Field [ Date, gFirstDate + gCounter ]
Exit Loop If [ gCounter = 6 ]
Set Field [ gCounter, gCounter + 1]
End Loop


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance