Variable Datestamp

[sg458]

Hello,
I have created a report which contains the data from the first of the actual month till yesterday. This report starts automatically every night and overwrites the old report.
Now my question:
In the headline I want to document the space of time the report belongs to.
For example: The Report runs tonight (26.05.2009). So the date in the header should be 01.05.2009 till 25.05.2009.
What is the instruction for this query?

 

[PWise]

try

Select convert(varchar(12),getdate()-day(getdate())+1)+'-'+convert(varchar(12),convert(varchar(12),getdate()-1))