-
1. Re: Is this possible?
pguerett Sep 28, 2011 10:28 AM (in response to dbjackie)If you look at this post I attached a sample that shows an example of a calculation between two dates.
http://forums.adobe.com/message/3262526#3262526
Paul
-
-
3. Re: Is this possible?
whyisthisme Sep 28, 2011 3:38 PM (in response to dbjackie)You can use (in formcalc) the Date2Num function to turn your dates into numbers which you can then subtract the end date from the start date to get the number of days in between. You could put that calculation into the restrictedDays field so it will calculate automatically without the need for a button.
-
4. Re: Is this possible?
dbjackie Sep 28, 2011 3:47 PM (in response to whyisthisme)thats exactly what i want to do. Now the hard part how??
I dont know how to write that script.. Any idea? -
5. Re: Is this possible?
whyisthisme Sep 29, 2011 12:03 AM (in response to dbjackie)the basic script (in formcalc) is:
$ = Date2Num(endDate.formattedValue, "DD/MM/YYYY") - Date2Num(startDate.formattedValue,"DD/MM/YYYY") // the DD/MM/YYYY part should be whatever format you have set your date fields to.
You put this script in the calculate field of the textbox. You may want to put in some extra code so you dont see a number until they have entered dates into both start and end date fields.
-
6. Re: Is this possible?
dbjackie Sep 29, 2011 8:41 AM (in response to whyisthisme)Wow thank you so so mcuh... That did it





