Hi experts.
I am trying to put together an easy COMBOBOX selection for the input section of a modified BPC script.
Basically, due to the way that our months are numbered, in general, month 001 is September (through to August being month 012), and everybody is used to this being the case.
However, for one of our exports, the month numbers are standard (Jan = 01, etc.), due to it feeding in to a different system that uses that format.
To avoid confusion, I would like to present the users with a list that is shown in name format, but with the selection converted to a number when they select it.
Is this possible?
e.g.
Instead of
PROMPT(COMBOBOX,%PER%,"Select Period",0,,{01,02,03,04,05})
I would like
PROMPT(COMBOBOX,%PER%,"Select Period",0,,{Jan,Feb,Mar,Apr,May}) - Then convert this to {01,02,03,04,05}
Thanks for taking a look and I hope that somebody has already wrestled with this sitiuation. :-)
Regards
Chris
NB - This is a BPC NW 10 system.