Problem with select options

[Former Member]

Hello,

I have an select options for field perid whose type is Char with length 7.

so my inputs are like AUG'08 , JUL'08 ,JAN'08 .....for perid.

my problem is perid-low if i am taking JUL'08 and

perid-high taking as AUG'08..

so here as perid is of type char, it is taking the ascii value of J and A and throwing message as Lower limit cannot be greater than Higher Limit... how can i avoid this ....

if i am taking lowerlimit as AUG'08 and upper limit as JUL'08 then it is working fine......

Please helpfull answers will be highly appreciated..

[Former Member]

Hi,

Can you please send your code for this, so that analysing the issue becomes more clear

[Former Member]

TO avoid this problem , you may have to work with two parameters side by side and behave them like a Select option.

this case you can overcome the error.

[Former Member]

Hi,

Can you please send your code for this, so that analysing the issue becomes more clear

[former_member585060]

Declare the SELECT-OPTION field Period as the field type which you will compare in the database table.