Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
Use text() or date#() function.
Hope it helps
may be you should assign values to monthfield (in string format)
as
load * inline
[
jan , 1
....
.....
dec,12
]
then link them it should work
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.