Having difficulties with Switch function, help please!

[surreal1780]

Hi,
I was trying to create a switch function that does the following:
• If the field “pre-date” has “group 1” selected, then the date in field “post-date” will = 01/01/2008
• If the field “pre-date” has “group 2” selected, then the date in field “post-date” will = 02/17/2008
• If the field “pre-date” has “group 3” selected, then the date in field “post-date” will = 03/14/2008
• If the field “pre-date” has “group 4” selected, then the date in field “post-date” will = 01/18/2008
• If the field “pre-date” has “group 5” selected, then the date in field “post-date” will = 05/21/2008

I tried the following function in the “post-date) field, but it did not work:

=Switch (pre-date=group 1, "01/01/2008", pre-date=group 2, "02/17/2008", pre-date=group 3, "03/14/2008", pre-date=group 4, "01/18/2008", pre-date=group 5, "05/21/2008")

Any suggestions?

Thanks in advance!

 

[pbaldy]

I'd guess that the values (group 1...) would have to be in quotes. I also suspect that the inadvisable dash in the field name will require it to be in brackets ([pre-date]).