J’ai trouvé ces expressions en faisant des recherches que je rajoute comme valeur par défaut à mes paramêtres StartDate et EndDate :


First day of last month:
=dateadd("m",-1,dateserial(year(Today),month(Today),1))
First day of this month:
=dateadd("m",0,dateserial(year(Today),month(Today),1))
First day of next month:
=dateadd("m",1,dateserial(year(Today),month(Today),1))
Last day of last month:
=dateadd("m",0,dateserial(year(Today),month(Today),0))
Last day of this month:
=dateadd("m",1,dateserial(year(Today),month(Today),0))
Last day of next month:
=dateadd("m",2,dateserial(year(Today),month(Today),0))

Ref : http://stackoverflow.com/questions/2059977/find-first-and-last-day-for-previous-calendar-month-in-sql-server-reporting-serv

 

Comments are closed.