No announcements

### Generate a list of array for weeks and months for a given two dates between a specify Date Range

List<MonthStartEnd> months = new List<MonthStartEnd>(); DateTime s = StartDate.Day == 1 ?
| 4 Replies | 884 Views | Created by denkyira - Friday, February 8, 2019 5:31 PM | Last reply by denkyira - Wednesday, February 13, 2019 12:31 PM

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

How to Calculate number of months,weeks,days for a date range Assume a calendar month is a ...
| 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

### Start and End date of a Given week of a Month

I want '2013-03-01 00:00:00.000' i.e. first date of that Month.
| 13 Replies | 2099 Views | Created by Sanjaya Kumar Mohapatra - Tuesday, March 19, 2013 6:48 AM | Last reply by --CELKO-- - Tuesday, March 19, 2013 4:45 PM

### find the month between two dates

Naren7, What would you require if the month or months between two dates are not in the same year?
| 5 Replies | 7156 Views | Created by Naren7 - Thursday, September 9, 2010 5:40 PM | Last reply by John Anthony Oliver - Thursday, September 16, 2010 3:58 PM

### Split date range into months

[date] between r.start_date and r.end_date group by Client, CONVERT(varchar(7), d.
| 7 Replies | 2383 Views | Created by MVP_88 - Tuesday, March 29, 2016 9:14 AM | Last reply by Sam Zha - Wednesday, March 30, 2016 3:25 AM

### Displaying result in a given date range

I have a while section about date range searches in here: http://www.karaszi.com/SQLServer/info_datetime.aspTibor Karaszi, SQL Server MVP | web | blog
| 4 Replies | 3112 Views | Created by Akien09 - Wednesday, December 21, 2011 5:30 AM | Last reply by TiborK - Wednesday, December 21, 2011 8:36 AM

### Start week of the month for a given week

I will need to split dates too, for example if a week covers two different months I will need to split that week the same for biweek ...
| 33 Replies | 1349 Views | Created by Jamesit0 - Thursday, July 23, 2015 5:10 PM | Last reply by --CELKO-- - Friday, July 24, 2015 4:25 PM

### Missing months between two dates

Using the calendar table to create a Cartesian between your operator numbers, and the first day of each month in the calendar table (I populated all of 2013) ...
| 4 Replies | 965 Views | Created by ShyamReddy - Thursday, September 11, 2014 10:48 PM | Last reply by Patrick Hurst - Friday, September 12, 2014 2:39 PM

### Search date range between two dates

Both methods worked to isolate units in the date range.
| 5 Replies | 552 Views | Created by Bigdstyle9 - Friday, March 25, 2016 10:06 PM | Last reply by Bigdstyle9 - Tuesday, March 29, 2016 9:28 PM

### grouping by date(formatting the dates by year or month, week or day

The users want to see the data grouped by year,month,week or day on their charts.
| 1 Replies | 1084 Views | Created by mhoran - Friday, June 10, 2016 4:11 AM | Last reply by Xi Jin - Tuesday, June 14, 2016 2:51 AM

### How to get records between two date ranges ??

I guess the item is created within the date range that you have specified.
| 8 Replies | 5211 Views | Created by Tzeng wei - Friday, July 30, 2010 2:19 PM | Last reply by tsengwei - Saturday, July 31, 2010 7:34 AM

### workday calculation for specified date range

[Day Of Week].
| 2 Replies | 716 Views | Created by BaskaranR - Tuesday, March 10, 2015 5:04 PM | Last reply by Simon_Hou - Wednesday, March 11, 2015 12:59 PM

### Convert Month to Range of Dates

The report period table gives a name to a range of dates that is common to the entire enterprise.
| 6 Replies | 1121 Views | Created by D2014KG - Tuesday, June 24, 2014 10:02 PM | Last reply by Visakh16 - Wednesday, June 25, 2014 5:11 PM

### Can't we implement "Date Range" / "Month Range" parameter ?

Hi, As mentioned above, we need to create two date type parameters like start date and end date and then apply range (1 month ...
| 4 Replies | 1929 Views | Created by G.V.Naidu - Wednesday, April 24, 2013 5:23 AM | Last reply by Mike Yin - Friday, April 26, 2013 3:29 AM

### Getting all months start and end dates between two dates

Just assign the columns to the variables to the solutions by experts above DECLARE @startdate date; DECLARE @enddate date; SELECT @stardate = ...
| 4 Replies | 2975 Views | Created by Eswararao C - Wednesday, July 13, 2016 10:20 AM | Last reply by Bangaaram - Wednesday, July 13, 2016 4:18 PM

### How to get period date of for a given month from a given date in mdx for SSRS report (mm/dd/yyyy)

Hi ram, Per my understanding that you want to get the period date based on the month selected and the given date, right?
| 2 Replies | 1180 Views | Created by ramprasad74 - Wednesday, December 17, 2014 3:37 PM | Last reply by Vicky_Liu - Tuesday, December 23, 2014 12:07 PM

### Create Weeks Number within Specified Date Range

sqlusa.com: i dont need a week generator.
| 16 Replies | 6025 Views | Created by Ismailc - Tuesday, March 1, 2011 7:53 AM | Last reply by Ismailc - Tuesday, March 1, 2011 2:58 PM

### how to get month end date between two dates.

It gives a name to a range of dates.
| 6 Replies | 7499 Views | Created by ikisb - Thursday, June 9, 2016 12:28 PM | Last reply by --CELKO-- - Monday, June 13, 2016 7:41 PM