Tuesday, November 11, 2014

MS CRM -SSRS Date Parameter - Set dafault Value First Day & Last day of Last Month

Date From: (previous month first day)


=DateSerial(Year(Now), Month(Now), "1").AddMonths(-1)

 

Date To : (previous month last day)

=DateSerial(Year(Now), Month(Now), "1").AddDays(-1)

 

Reference:

http://stackoverflow.com/questions/7842877/first-and-last-day-of-current-month

 

No comments:

Post a Comment