how to get a gl balance for a date

Hi,

I am trying to develop a reprt for a gl transaction from user entered date. The problem i am facing is fi table contains data for a period. So whenevri try to fetch opening balance it comes from start of the month not from any date into the maonth say 10th.

Please provide me code to capture the balance of gl in any day of the month.

CHEERS