How to calculate CORRECTLY with intervals :

when the date1 = '31/01/2006'
then "select date1 - 1 units month .. " results in '31/12/2005'
tht's fine

but
with " select date1 - 2 units month .. " results in
" The result of a datetime computation is out of range"
because '31/10/2005' doesn't exists

the same with "31/01/2006" + 1 units month
How to calculate correctly ??

Hi,

If you are concerned with only last dates of the month, then may be you can use the following:

select -- n months previous end day (eg below is 4 months) -- ( biggest frig comparred to the others)
current year to day -3 units month - (day(current)) units day as prevN_month_end

from systables
where tabname = 'systables'


Bye

Nitin

Hi,

yes, like to be a ,right answer.

Thanks
Yves