Sql Between Clause Confusion

See more:

SQL

Lets say i have 1 table Contain record of itemcode,batchano,opening stock ,receipt stock, issue stock ,Closing Stock,adddate
receipt is opening + recept =closing
issue is closing-issue
and i have made transaction form grn(Good Receive Note Receipt having grndate on which date it is added) and MIN(Material Issue Note Issue and mindate)

Now i want record as on date
let say on today 12/12/2012

so in my condition where clause

my To Date will be 12/12/2012
and FROM Date on which date record has inserted so how could i get this date