Sir i need a help that i want to assign a specific date and time into whinr110.trdt..

ex of my codes..

domain tcqdhc jan
domain tctrns.date jandate

domain tcqdhc feb
domain tctrns.date febdate

after.whwmd215.item.1:
before.layout:

|January date
jandate = 01-31-2010 23:59

select whinr110.qhnd,whinr110.trdt
from whinr110 |where whinr110.trdt < :trdt.f
where whinr110.trdt <= :jandate
and whinr110.cwar={:whwmd215.cwar}
and whinr110.item={:whwmd215.item}
selectdo
jan=whinr110.qhnd |ENDING INVENTORY of the Month January
endselect


|February date
febdate = 02-31-2010 23:59

select whinr110.qhnd,whinr110.trdt
from whinr110 |where whinr110.trdt < :trdt.f
where whinr110.trdt <= :febdate
and whinr110.cwar={:whwmd215.cwar}
and whinr110.item={:whwmd215.item}
selectdo
feb=whinr110.qhnd |ENDING INVENTORY of the Month February
endselect

the report is just like this

ENDING INVENTORY PER MONTH
|January|February|
| 2000 | 3000 |

Thnxs,,

The problem is my statement is not working..need help for the codes..

Sir i need a help that i want to assign a specific date and time into whinr110.trdt..

ex of my codes..

domain tcqdhc jan
domain tctrns.date jandate

domain tcqdhc feb
domain tctrns.date febdate

after.whwmd215.item.1:
before.layout:

|January date
jandate = 01-31-2010 23:59

select whinr110.qhnd,whinr110.trdt
from whinr110 |where whinr110.trdt < :trdt.f
where whinr110.trdt <= :jandate
and whinr110.cwar={:whwmd215.cwar}
and whinr110.item={:whwmd215.item}
selectdo
jan=whinr110.qhnd |ENDING INVENTORY of the Month January
endselect


|February date
febdate = 02-31-2010 23:59

select whinr110.qhnd,whinr110.trdt
from whinr110 |where whinr110.trdt < :trdt.f
where whinr110.trdt <= :febdate
and whinr110.cwar={:whwmd215.cwar}
and whinr110.item={:whwmd215.item}
selectdo
feb=whinr110.qhnd |ENDING INVENTORY of the Month February
endselect

the report is just like this

ENDING INVENTORY PER MONTH
|January|February|
| 2000 | 3000 |

Thnxs,,

The problem is my statement is not working..need help for the codes..

Hello,

do not post the same problem in different forums
or with different headlines, please !!!!!

Regards

Sorry Sir for the Double Posting of same problem..Ill just have a problem in a codes..