These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Help!! Stuck on Sorting

Forum Index > JavaScript > Help!! Stuck on Sorting
2011-11-20 18:43:40
sammie
Registered: Nov 8 2011
Posts: 3

I have a form that a user can enter a start and end date. The user also enters a column of dates with another column of numbers next to it, much like:
 
Start: 09/01/11 End: 10/31/11
 
10/02/11 $12.50
11/11/11 $ 5.68
10/26/11 $32.56
05/17/11 $54.32
09/01/11 $42.10
 
I am trying to figure out if I can have a field look at the dates and if it is in the start and end date range then it will pull those dollar amounts out and give me a total. For this example the total would be $87.16.
 
If anyone knows where a tutorial is to guide me in learning this or even let me know if it is possible I would appreciate it.

My Product Information:
Acrobat Pro 10.0, Windows
Top
2011-11-20 22:14:08
#1
gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4307
You need to convert the character date strings to numeric values like the number of milliseconds since the Epoch date. Look at the tutorial for date calculations.

George Kaiser

Top