Hello..
I have a text box which I have configured for a drop-down list and it has a list of item with values.  This is for the date of a month; 1|1st;2|2nd;3|3rd;4|4th; etc.  I've done the same for the month; 1|January;2|February; etc.  When viewed in the list, I need the information to show up as January 5th, February 23rd, etc depending on what the end-user selects in the drop-downs; thus the reason for the pair values.

As part of the sorting of the list, I'm trying to take the values of these two columns plus the year to create a calculated field which is a date data type to sort the items.

If I set the expression of the calculated column to [Month.Value] + '/' + [Date.Value] + '/' + [Year], I get an error stating that it Cannot find column [Month.Value].

I've tried configuring the value pairs as 1st|1;2nd|2; for the date and Janauary|1;February|2; for the month for testing purposes, but I keep getting the same cannot find column error.

Any ideas on why this isn't working properly?  Did I find a bug?  Thanks..  -Jeff

Hello Stefan..  Thanks for the reply..

I guess I was just misunderstanding the use of the paired values then.

Could I grab the paired values for the month and date to create a date string in the calculated column?  If so, how can I accomplish this to generate the proper date sting?

I'm using the list for archived audio files and the creation date is going to be different than the actual record date.  I need to filter the list to only show that last 90 days of recordings.  Instead of the end-users having to select a date with a date column (it came up when I showed them; "Why do I have to enter the date of the audio files twice?!"), I thought I could use a calculated column to auto-generate a date using the month, date and year values and then filter using this column.

Thanks again for the reply.  -Jeff

Thank for the reply Stefan..

I have a question, may you better explain how the filter works?

[Ticks:Today]  - [created at_UDT_Ticks] < (30 + 31)  * [Ticks:TicksPerDay]

Thanks.. -Jeff