AKILAN

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

 

Posted by Unknown at 9:53 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Archive

  • ►  2017 (1)
    • ►  February (1)
  • ►  2016 (3)
    • ►  April (1)
    • ►  January (2)
  • ►  2015 (5)
    • ►  May (2)
    • ►  March (1)
    • ►  January (2)
  • ▼  2014 (7)
    • ►  December (1)
    • ▼  November (2)
      • MS CRM - SSRS Reports Display Values in Footer -...
      • MS CRM -SSRS Date Parameter - Set dafault Value F...
    • ►  August (1)
    • ►  July (2)
    • ►  May (1)
  • ►  2013 (13)
    • ►  November (1)
    • ►  September (2)
    • ►  July (2)
    • ►  June (2)
    • ►  March (2)
    • ►  January (4)
  • ►  2012 (55)
    • ►  December (1)
    • ►  November (5)
    • ►  October (9)
    • ►  September (12)
    • ►  August (9)
    • ►  July (2)
    • ►  June (1)
    • ►  May (6)
    • ►  April (7)
    • ►  March (3)
  • ►  2011 (1)
    • ►  January (1)

Search This Blog

Total Pageviews

Watermark theme. Powered by Blogger.