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
Wannabe FoxPert!!!