Probably gives you the prior day. What Cognos product are you using? Impromptu should offer you add-months as a function; add-months(<datefield>,-1) will give you the same day in the prior month.
Or have I misunderstood what you're attempting to retrieve?
soi là, soi carré