I am having a formula issue and was hoping for some assistance. 

 

Basically, I am attempting to write a formula to identify what time zone a given address record is in.  I found an Excel file that decodes time zone from a zip code.  However, when I try to put this data into a formula field, Crystal immediately shuts down.

 

I tried a select statment that looks like this:

 

select {ADDRESS.ADR_ZIP}
case '52501': 'Central'
case '56972': 'Eastern'

etc

etc
default: 'Others'

 

I'm sure my issue has to do with the sheer length of my select statment - it is over 20,000 lines long.

 

Any ideas on what I could do to correct?

 

Thanks in advance for any assistance you can provide.

 

~Stephen