Sql Command For Dates In Delphi-5 Sql Builder

[Ian Clarke]

Seeking your assist to find SQL command to summarise the daily values for current month (also previous and future 2 months) in Delphi SQL Builder. Purpose is to dynamically graph (DBChart) the last, present and future 2-months of monthly workload (forecast) based on the daily values in order to better schedule production.

[debasisdas]

Kindly pass few more details on this along with your table structure.

And what is the logic that you are using for forcasting.