Jump to content
Sign in to follow this  

Script for Range of Dates

Recommended Posts


I´m working with a solution that works with dates, a date range for example May 1-7, May 8-14, the solution already gives me this range of dates and each day in some fields, the problem is that I don´t know how to do this range of dates for example when is May 29 - Jun 4 the whole week goes between two different months!!

my question is if somebody knows how to do this in filemaker or if there is already a funtion in filemaker that has something like nextday function and with that is easier to pull it off.

I´m working with FMP 9 Advance

thanks people


Share this post

Link to post
Share on other sites

Your question is not clear: it's not clear what you have, nor what do you want to do with it.

Filemaker can easily work with a date range, if it's given by two date fields. A text field, like "May 1-7" is just a meaningless string of characters (unless you make the effort to parse it into two dates).

Share this post

Link to post
Share on other sites


I´m going to explain it better.

I need to put in some date fields a certain ranges of date, each day for field. I have a process already to do it when it´s a range inside a month, but if the range goes between two different months I don't know how to tell it to filemaker that gives me the date of tomorrow???

for example range date: may 1 - may 7

setfield: may 1 to field1

setfield: may 2 to field2

setfield: may 3 to field3

setfield: may 4 to field4

setfield: may 5 to field5

setfield: may 6 to field6

setfield: may 7 to field7

but if the range date goes like this: may 29 to 4 jun

I don't know how to establish this range of date


Share this post

Link to post
Share on other sites

I still don't understand what you're doing - and even less WHY would you need to do this. In any case, if you have a starting date, you could do:

Set Field [ field1 ; StartDate ]

Set Field [ field2 ; StartDate + 1 ]

Set Field [ field3 ; StartDate + 2 ]

Set Field [ field4 ; StartDate + 3 ]


and so on.

Of course, it would be easier to make them calculation fields and eliminate the need for a script.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.