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