Hi!

Following expression probably will help you. The main idea is the same, but you need to use other functions on SQL server:

dateadd(dd,-1,dateadd(mm,1,'10/01/2000'))

returns 2000-10-31 - last day of the 10-th month.


>Hi All
>
>Can anyone please help with this one :
>
>In my VFP front-end and back-end i use this syntax to get to the end of a month
>
>depdate.date = "31/01/2000"
>endmonth = gomonth(depdate.date - day(depdate.date)+1,2) -1
>
>this works fine in VFP
>but with a SQL 6.5 back-end the depdate.date field is a date time field and with the above syntax it adds 1 second to this field and not 1 month.
>
>I have my date set as SET DATE BRIT
>and SET CENTURY ON
>and i am using views in this case
>
>Any suggestions??
>
>Thanks in advance
>Fida