Re: Need simple SQL to get the last day of month of previous month

ok thanks those are good.

On Thu, Oct 22, 2015 at 9:13 AM, Glenn Gundermann <
glenn.gundermann@xxxxxxxxx> wrote:

How's this?:

select * from (values(current_date - day(current_date) days )) t (date) ;


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144


On 22 October 2015 at 12:08, Glenn Gundermann <glenn.gundermann@xxxxxxxxx>
wrote:

1. Find first dayof current month
2. Subtract one day


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144


On 22 October 2015 at 11:57, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

HI this code is not working on i.
select DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1)

error Message: Token <END-OF-STATEMENT> was not valid. Valid tokens: + -
AS
<IDENTI

What would be the syntax for such a select statement?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.