Date multikey not working

[BertBoye]

I am trying to make a multi key from to dates. I have 3 drop down menus to select start date and 3 to select end date.

I have a calculation field like this:

TextToDate(Case(month_search="january", 1, month_search="February", 2, month_search="March", 3, month_search="April", 4, month_search="May", 5, month_search="June", 6, month_search="July", 7, month_search="August", 8, month_search="September", 9, month_search="October", 10, month_search="November", 11, month_search="December", 12)&"/"&day_search&"/"&year_search) & ""

&TextToDate(Case(month_search="january", 1, month_search="February", 2, month_search="March", 3, month_search="April", 4, month_search="May", 5, month_search="June", 6, month_search="July", 7, month_search="August", 8, month_search="September", 9, month_search="October", 10, month_search="November", 11, month_search="December", 12)&"/"&day_search&"/"&year_search) +1

The result of this is:

731288731289

I want this,

731288

731289

Anybody know what

[ryanzon]

Do this: (i just added "

[BertBoye]

It is there but it does not show up then I paste the calculation in to this text box. So the end is "

[Lee Smith]

equals the Define Fields Paragraph symbol in the middle box when building a calculation.

HTH

Lee

BTW, next time you post, check the smilie section for the new symbols added just for this purpose.