No announcements

### Counting days every month

| 2 Replies | 576 Views | Created by s.pac - Sunday, January 11, 2015 10:26 PM | Last reply by s.pac - Monday, January 12, 2015 1:26 AM

### Average per day of week

[Day of Month].
| 8 Replies | 10614 Views | Created by Mattias Engblom - Thursday, March 31, 2011 12:01 PM | Last reply by Mattias Engblom - Monday, April 4, 2011 2:11 PM

### Days count for each month

This will be get you the days in each month for 2008.
| 2 Replies | 3760 Views | Created by MANOJ MATHE - Thursday, September 25, 2008 8:29 AM | Last reply by Anand Pandey - Thursday, September 25, 2008 9:01 AM

### calculate number of months,weeks,days for two dates

Jan 15, 2012 & April 15, 2012 : Feb 2012 = 1 Month Mar 2012 = 1 Month Jan 15 - Jan 31 = 2 Weeks + 3 Days April 1 - April 15 = 2 Weeks + 1 Day ...
| 23 Replies | 11615 Views | Created by JR1811 - Wednesday, August 15, 2012 6:02 PM | Last reply by JR1811 - Thursday, August 16, 2012 9:04 PM

### Retriving the days count in a month

Hi,   I want the days count in particular month exp: if january it has 31 days like that i want the output as ...
| 1 Replies | 3374 Views | Created by MANOJ MATHE - Thursday, September 25, 2008 8:29 AM | Last reply by Anand Pandey - Thursday, September 25, 2008 8:59 AM

### Time Dimension: From Months to Days

And the time dimension has year/month/day/hour/min/sec levels.
| 4 Replies | 5249 Views | Created by LuckyJim1001 - Monday, August 9, 2010 3:28 PM | Last reply by rok1 - Monday, August 9, 2010 5:52 PM

### Counting Issues min/max records per day/week/month

Yes, I agree that the case will be only actual days belonging to the month
| 9 Replies | 4819 Views | Created by NCODDING - Wednesday, October 21, 2009 7:41 PM | Last reply by Kent Waldrop - Thursday, October 22, 2009 12:50 PM

### Convert Minutes to Years Months Weeks Days Hours

DECLARE @Sample TABLE ( Value INT NOT ...
| 5 Replies | 8740 Views | Created by MrMNew - Monday, May 2, 2011 9:06 PM | Last reply by Kalman Toth - Friday, May 6, 2011 5:36 PM

### Get Month and Day Different

By me adding one full day to the ending date, it's exactly one full day too many!
| 6 Replies | 733 Views | Created by Surbakti - Monday, September 26, 2016 5:06 AM | Last reply by Mr. Monkeyboy - Monday, September 26, 2016 10:34 PM

### Retrieve weeks in month for next month

[Weeks in Month] AS COUNT(EXISTING [Date].
| 3 Replies | 5728 Views | Created by Andrew Oliver - Tuesday, May 17, 2011 5:06 AM | Last reply by Andrew Oliver - Tuesday, May 17, 2011 11:03 PM

### Last day of month and last day of the week Using MTD,YTD

[Month].
| 2 Replies | 5624 Views | Created by ABHISHEK PARIHAR - Saturday, September 25, 2010 6:14 PM | Last reply by ABHISHEK PARIHAR - Saturday, September 25, 2010 7:50 PM

### days in a month

Thus, I wrote a blog post about the solution, which you can find here: ...
| 5 Replies | 4839 Views | Created by datadudedub - Wednesday, May 11, 2011 8:12 AM | Last reply by datadudedub - Thursday, May 12, 2011 8:25 AM

### MDX to Count Days/Business Days

[Fiscal Month].CHILDREN ON ROWS FROM Visits WHERE [ApptDate].
| 4 Replies | 2202 Views | Created by siera_gld - Friday, May 12, 2017 11:40 PM | Last reply by siera_gld - Monday, May 15, 2017 3:44 PM

### month names and month days between two days

| 7 Replies | 5303 Views | Created by sunny0817 - Friday, December 23, 2011 5:22 AM | Last reply by Jeff Moden - Wednesday, July 27, 2016 3:06 AM

### Cumulative total for current week days and previous week

DATEDIFF() doesn't allow you to specify a week start day, so we need to subtract 1 from the DATEDIFF() on Sundays.
| 3 Replies | 2102 Views | Created by Maracles - Monday, November 30, 2015 3:48 PM | Last reply by greggyb - Tuesday, December 1, 2015 11:51 PM

### Day of the week from a parameter

Since you are using Weekday to generate a number from 1 to 7 to represent the day of the week, it will depend on your system settings what the first day ...
| 3 Replies | 4350 Views | Created by Kiwi_wizz - Thursday, June 9, 2011 9:51 PM | Last reply by Martina White - Sunday, June 12, 2011 2:14 AM

### Report Parameters pTimeframe (Day - Week - month)

While creating the data-driven subscription, the report only be sent with 24 hours prior data from the time that the subscription is firing.
| 2 Replies | 571 Views | Created by Christoph Reusch - Thursday, August 6, 2015 12:00 PM | Last reply by Qiuyun Yu - Friday, August 7, 2015 11:28 AM

### Calculating the last day of a month

I just did this last week.
| 8 Replies | 3099 Views | Created by SteadyData - Monday, February 13, 2012 6:14 PM | Last reply by - Friday, February 17, 2012 10:39 AM