Thanks everyone - got it now. cathryn -----Original Message----- From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jean Libert Sent: Friday, October 10, 2008 11:59 AM To: [log in to unmask] Subject: Re: date value function in CRXI The best way is to create a very simple formula for the date. My instructions are very ABC. 1) Create and name a new formula in formula editor 2) Middle box in formula editor is Functions. Click the little "+" next to "Type Conversion" to open it up 3) do the same next to "CDate" to open it up 4) double click "CDate (dateTime)" that will display CDate () in the box below with the cursor in the middle of the parenthesis 5) In the first box chose the date report field that you want to customize 6) Save and close on top - your date formula is done. Now put the formula in the report, right click format field and choose the date format you want. Hope it works. Jean. Chad Petrovay <cpetrovay@THEWAL TERS.ORG> To Sent by: "The [log in to unmask] Museum System cc (TMS) Users" <TMSUSERS@SI-LIST Subject SERV.SI.EDU> Re: date value function in CRXI 10/10/2008 11:46 AM Please respond to "The Museum System (TMS) Users" <TMSUSERS@SI-LIST SERV.SI.EDU> I’ve been playing with the following: ToText(CDATE({wam_rLoans.EndDate}),"d MMM yyyy") You may want to hit F1 and check the Date syntax for ToText to meet your own needs, and you’ll need to update the field, since I used a custom view. Chad M Petrovay Collections Database Administrator The Walters Art Museum 600 North Charles Street Baltimore, MD 21210 P: 410.547.9000 x266 F: 410.837.4846 [log in to unmask] www.thewalters.org Exhibitions: Bedazzled: 5,000 Years of Jewelry on view October 19, 2008 through January 4, 2009 Sonya Clark: Loose Strands, Tight Knots through September 21, 2008 The Special Dead: A Medieval Reliquary Revealed through January 18, 2009 -----Original Message----- From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Cathryn Goodwin Sent: Friday, October 10, 2008 11:38 AM To: [log in to unmask] Subject: date value function in CRXI Does anyone have a solution for getting Crystal to display venue dates in Month Day, year format? The DATEVALUE function does this nicely for iso dates in the loan table, but I can only get nn/nn/nnnn from the venue dates? Also, have already set the report options to display dates in the Month, day, year format. Thanks cathryn CONFIDENTIALITY NOTICE: This email and any attachments thereto are intended solely for use by the recipients named above and may contain confidential information. If you are not an intended recipient of this e-mail or if you otherwise received this email in error, you are hereby notified that any disclosure, copying, distribution or use of this e-mail or any attachment is strictly prohibited. Please notify us immediately by returning it to the sender and permanently delete this message and any attachments from your system. You should not retain this e-mail, nor should you disclose all or any part of the contents to any other person. Thank you for your cooperation.