last month

[HrvojeVd]

I would like to get the day of previous month?

I tried currentdate - 1 but it doens't work.

 

[drlex]

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é

 

[blom0344]

Cognos 8 offers the _add_months function as well, so it would be:

extract(month,(add_months(current_date,-1))

Ties Blom

 

[HrvojeVd]

I tried this function but it doesn't work.

 

[blom0344]

extract(month,(_add_months(current_date,-1)))

Just tested it. works as designed..

Ties Blom