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

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
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