[wp-pro] Requesting Assistance (Paid)

[ChautCo]

Looking for someone who can come up with a sort solution on posts  
category page involving sort order based on custom field value. 99%  
of the work is already done, just having issues on next/previous page 
(s) which I'm sure could be sorted out by somebody well-versed in WP.

The issue in a nutshell:

Want to have category page sorted by custom field value (a date YYYY- 
MM-DD ) in ascending order.
Currently using category-#.php with a custom select (left join) to  
display information.

- If no restrictions on # of results to display, entire page is  
sorted correctly.
Not a good idea as there will be a total of about 115 posts.

- if restricting to 5, 10 any number per page, results are displayed  
in correct order, but in the sequence of the default wp query (order  
by post date).

Example - limit to 5 per page, custom field dates range from June to  
August, and there are 6 posts per month.

On 1st category page, results showing range from June 06, to August  
14, and are arranged by custom field date.
On 2nd category page, results showing range from June 30 to July 07,  
and are arranged by custom field date.

The problem is, the first page should technically show the first 5  
posts with the custom field date value of June, the second page  
should show the last "June post" and 4 "July posts", etc.

Have explored all different kinds of options for solving this problem  
to no avail and at this point willing to pay for assistance and/or  
solutions.

Please get back to me with rates/fees and any questions....

Thanks!