Hello All!

I know this is simple, but math was never my best subject. I need to create a looping script that adds 1/2 hour base on a start and end time. I use global's and set fields to set up the script. The problem is with the counter, here is the script:

Set Field [gnexttime,gtimestart]

Loop

New Record/Request

Set Field [timestart,gnexttime]

Set Field [gnexttime,gnexttime (this is where I need help with the counter to increase the next time by 1/2 hour)]

Exit Loop if [gnexttime>gtimeend]

Any help is appreciated!!!

Hi

Set Field [gnexttime,gnexttime + 1800]

because FileMaker works in seconds for time, so 30 minutes * 60 seconds = 1800

HTH

Thanks Andy!

I knew it was relatively simple, works fine now.

All the best!