Hi Pete, Here are a couple options:
1. If your DB supports Case, you can do a set fields using SQL. 2. You can store the values in a separate form, then set the values from that. We use the second option, as it seems a lot easier to maintain. We've got a form which stores the month in 4 fields. M is 1-12, MM is 01-12, MMM is Jan-Dec, and MMMM is January-December. This allows easy conversions between any of these formats. Eric Cleereman -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joran, Peter P, CTR, OSD-CIO Sent: Tuesday, November 13, 2007 11:30 AM To: [email protected] Subject: Is a Case function possible in Remedy? All Is there a way to do a case function, or something like it, in remedy for a set fields action? For example: If 1 than January If 2 than February... Thanks Pete ARS 6.3 SQL Server 2000 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
