Date Calculation with formcalc

The Num2Date function is what formats the date. So this is where you need to add a formatting parameter, like this.

Num2Date(Date2Num(DOB.formattedValue, "MMM D, YYYY") + (365.25*65), "MMM, YYYY" )
And yes, there is a better way to do the calculation. You're a bit off because of rounding in the leap year fudge. A better method would be to simply split out the components of the DOB and add 65 to the year. Then rebuild the date strintg.

Something like this


Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/]http://www.adobe.com/devnet/acrobat/[/url]

Thank you very much! That was exactly what I was trying to do.

I am planining to use my form that once user enters date of birth to one field next field (age) supposed to calculate and display age (year only). Is this possible? So in this case I am trying to display date of birth as well as age in two seperate fields.
please help.. By the way I am bit new to LiveCycle
Thanks
Disssg

There are actually quite a few ways to do this. Some of the simpler methods can get tripped up by leap years, but for the most part they are close enough. Here's a post that explains one.

http://www.acrobatusers.com/forums/aucbb/viewtopic.php?id=587

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

I need a sample of a calculation to determine the number of days between two dates. I have tried to understand from the posts that you have recommended, but I can't seem to get it - HELP!

@ susuns

Hi,

look at this thread.
[url]http://www.acrobatusers.com/forums/aucbb/viewtopic.php?id=21544[/url]

Depending upon what days you are counting, you may need to include the start day as a counted day, like in computing days present at a location or for age calculations. For this situation, you will need to add 1 to the result.

I have been trying to figure out the script to determine the number of days that have passed since a date in Livecycle Designer.

For example, if I input a date in one field, I would like the field next to it to determine how many days have passed since that date.

Can anyone help me out with any copy and paste code?

You could create a field with todays date and then use that date for the ending date and the imputed date for the starting date. With those 2 fields you should be able to use the 'Num2Date' function to convert the formatted string values for the date to the number of days since the epoch date and the difference of those 2 dates plus 1 will be the number of days that have past.

With out knowing the exact name of the fields and the exact format for the date fields, it is very hard to provide a cut and paste code.