Data types

[#1]

I have two fields that I'm trying to link in my script.  Both are the 3 letter abbreviations of the months like 'Jan', 'Feb' and such. 

When I link them I get double the months in a selection box with some of them right aligned(text data type) and some aligned right(number data type), I need them all to be number data type.  I've tried using num() (that turns the "string" to an actual number), num#() and, date().  None of them works to give me linked months that work correltly in my charts.  Any ideas?

[MayilVahanan]

Hi

     Use text() or date#() function.

Hope it helps

[Anonymous]

may be you should assign values to monthfield (in string format)

as

load * inline

[

jan , 1

....

.....

dec,12

]

then link them it should work

[#4]

Sorry.  I knew this should work.  I just had an accidental link with another table in the two tables I was linking that was screwing this up.