update on the problem: i guess some of the records have somehow affected the field paystart and not sure how it happened. when i deleted some records, it began to produce the correct results expected and its working now. Its just i wasn't able to find out what really went wrong and how those records ive deleted have affected the results

Thanks for your suggestions