Jump to content
Sign in to follow this  
BluiSh

Script for Range of Dates

Recommended Posts

Hello!

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

BluiSh

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

Sorry!

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

BluiSh

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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