Calculating Dates - help please


hi

i need using date/time object.
i want have 2 date/time objects.
arrival , departure

and have third numeric text object subtract 2 dates , calculate days.

i've gone through forums , found these 2 topics
thierry stortenbeker, "date manipulation" #2, 16 nov 2005 5:27 am
http://www.adobeforums.com/cgi-bin/webx?7@@.3bbd44ca/4

they seem have provided solution couldn't work out how use code because i've never used formcalc. possible in javascript? if not can explain how use formcalc script mentioned here.

thierry stortenbeker, "date manipulation" #2, 16 nov 2005 5:27 am

any appreciated
thanks

if want find number of days between 2 dates, use formcalc function date2num. in third numeric field, add following calculate event...

>date2num(datetimefield1.rawvalue, "yyyy-mm-dd") - date2num(datetimefield2.rawvalue, "yyyy-mm-dd")

if result more 365 days, might want add code convert days years, months, etc.


More discussions in LiveCycle pre-ES (6.x and 7.x) discussions


adobe

Comments