You simply insert all the with the current datetime (C# DateTime.Now or SQL getDate()).
At the end of the month run your query.
select * from Data where created >= '1 day on month' and created <= 'last day of the month'
e.g select * from data where created >= '1 March 2011' and created <= '31 March 2011'