Concatination/trim

[JuliaM]

Hi All,

I need help please!
I have a report where I show curernt month, next month and next month + 1 (Dec, Jan, Feb). I extract current month and year from sysdate, calculate next year, next month, convert form num to char and then concatinate into year+month to compare with DB values. However, after after concatination, I get '20131', not '201301' as I need.

Any suggestions?

Thank you!

[RubenvdLinden]

Extract the year and multiply by 100, then extract the month and add (+) it to the result.

For example:
extract(YEAR; [Date]) * 100 + extract(MONTH; [Date])

[JuliaM]

Thanks!