No announcements

### Schedule last day of the month?

Our business absolutely needs the ability to run a report as late as possible on the last day of each calendar month, NOT on the first day of ...
| 3 Replies | 13296 Views | Created by J Quick - Thursday, September 8, 2005 10:59 PM | Last reply by Lewis Butler - Wednesday, January 8, 2014 3:17 AM

### Challenge of Deployment

;Automation Addin" working with Excel (it is named AutomationAddin in the book). Everything works fine when the Addin is built inside of Visual Studio ...
| 4 Replies | 3459 Views | Created by janetfan95758 - Wednesday, November 22, 2006 1:50 AM | Last reply by dsamperi - Sunday, September 30, 2007 10:13 PM

### number of the week of the current month

Whoops - didn't read the question carefully enough this early on a Monday morning. This will give you the number of the week of the year, not ...
| 4 Replies | 3157 Views | Created by VBE_programmer - Monday, September 18, 2006 2:50 PM | Last reply by VBE_programmer - Tuesday, September 19, 2006 10:23 AM

### Calculating the last day of a month

within a given month, you'd want to the date to be less than or equal to  (for example) "Jan 31, 2011 23:59:59.999" (a.k.a. one tick of the atomic ...
| 8 Replies | 2961 Views | Created by SteadyData - Monday, February 13, 2012 6:14 PM | Last reply by - Friday, February 17, 2012 10:39 AM

### Find the Beginning Day of the Month

dealing with the year and month), if this code is being executed very near the turn of the year, it may come up with the wrong ...
| 4 Replies | 3242 Views | Created by Mattaniah - Wednesday, August 20, 2008 3:52 PM | Last reply by Mattaniah - Wednesday, August 20, 2008 6:09 PM

### nth day of the month

Without having to build an array, how can I extract a certain day of the month to result as nth. Example I want to extract from 10/5/2007 the ...
| 4 Replies | 2830 Views | Created by jr50 - Thursday, October 4, 2007 6:49 PM | Last reply by John Anthony Oliver - Friday, October 5, 2007 2:50 AM

### First day of month

You can use Month-Year: DateSerial(Year([Completed/Returned]), Month([Completed/Returned]), 1) Set the Format property of this ...
| 1 Replies | 306 Views | Created by PatYak - Friday, July 31, 2015 4:46 PM | Last reply by Hans Vogelaar MVP - Friday, July 31, 2015 4:48 PM

### last monday of month

Hi, Calculate the number of days in a month, then loop backwards (for efficiency) checking DayOfWeek: static DateTime? ...
| 5 Replies | 6837 Views | Created by arkiboys - Wednesday, June 6, 2012 8:12 AM | Last reply by OmegaMan - Wednesday, June 6, 2012 2:28 PM

### Week of Month

Is there a DAX function to get the week of the month from a date field?MSDNStudent Knows not much!
| 1 Replies | 3914 Views | Created by MSDN Student - Monday, December 5, 2011 4:04 PM | Last reply by Eddy Nijs - Tuesday, December 6, 2011 9:32 AM

### Cal first day of the month

.  What is the last day of the month?  select max(day) from calendar where month = 9 and year = 2007.  Or even add yourself a column for ...
| 4 Replies | 5550 Views | Created by ksri - Thursday, January 31, 2008 12:02 AM | Last reply by Louis Davidson - Thursday, January 31, 2008 4:21 AM

### Start/End of month

/content/FirstAndLastDaysOfMonth.aspx about how to find the first day of a month and the last day of a month. You can also You can download ...
| 5 Replies | 7879 Views | Created by Lawrence 007 - Monday, March 12, 2007 3:16 PM | Last reply by Lawrence 007 - Tuesday, March 13, 2007 1:11 PM

### date of the first day of the month

Hi, I am a beginner, I have to make a report in which the date should be always be the first day of the week i.e "Monday's Date."of any given ...
| 1 Replies | 1183 Views | Created by 'G' the great - Wednesday, March 27, 2013 2:42 PM | Last reply by Sachi_SG - Wednesday, March 27, 2013 3:49 PM

### today -2 month & last of that month

, Date.Today.Month)) This create a date object with the last day of current month. You can change the Date.Today to other date object so that it ...
| 3 Replies | 4321 Views | Created by alex121 - Tuesday, June 13, 2006 7:45 AM | Last reply by cwlaualex - Tuesday, June 13, 2006 9:37 AM

### Format Alert on days of the month!

Hi, The number of days last month should be a simple: DateSerial(Year(Date),Month(Date),0) Right?
| 9 Replies | 393 Views | Created by TurnipOrange - Friday, February 3, 2017 10:01 PM | Last reply by .theDBguy - Saturday, February 4, 2017 11:30 PM

### Function for last Sunday of the month

It is much simpler in SQL Server 2012 T-SQL: -- Last Sunday of the Month SQL Server 2012 DECLARE @Date date = '2013-04-15'; SELECT ...
| 14 Replies | 12158 Views | Created by knra - Friday, October 5, 2012 3:34 AM | Last reply by luvalle - Monday, June 25, 2018 1:21 AM

### Last Day of The Previous Month

T-SQL How-To Get First Day of the Month
| 27 Replies | 14147 Views | Created by SSRS New Bie Beginner - Friday, March 19, 2010 3:22 PM | Last reply by NB515 - Monday, April 15, 2013 7:30 AM

### GETDATE() select 1st day of the month

i was hoping it would return 2012-10-01 00:00:00.000, this being getdate() minus 3 months, so it should return the first day of that specific ...
| 6 Replies | 2949 Views | Created by Sam233 - Wednesday, January 16, 2013 11:51 AM | Last reply by Sanjeewan Kumar - Wednesday, January 16, 2013 3:23 PM

### Need last day of the month.

I have to get the last business day of the month querying a date
| 5 Replies | 586 Views | Created by Bryan_P_Murtha - Thursday, December 7, 2017 3:27 PM | Last reply by Tom Phillips - Thursday, December 7, 2017 5:59 PM