period field with two digits

[#1]

Hi everybody,

I hope someone of you could help me.

I am trying to Show a period-field with two Digits but I dont get it to work.

The Problem is that the period field is not part of a calender. It is just one field with number from 1-12.

(It is the used period, the date can be different from that period, therefore it is not part of the calendar.

I tried yr&'-'&period, '00' AS BuP, but this does not work.

How can I get 01 until 09 for the months January to September?

Does someone of you have an idea?

Very much thanks in advance.

Chris

[swuehl · Accepted solution]

yr & '-' & num(period, '00') AS BuP

[anbu1984]

yr&'-'&Right('00' & period,2) AS BuP

[#4]

thank you so much. You cant imagine, how long I have been searching for that, since I am not part of IT-Department.