The server date format used in filters will be set by the lang/locale of the environment the server is running under. Are you using a Unix server - if so check the arsystem script for the LANG setting as it sounds like it may be set to C. To get a UK date format this will need to be changed to en_GB or similar.
Mark Walters The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Clements, Paul (Access LLP) Sent: 08 September 2009 11:52 To: arslist@ARSLIST.ORG Subject: 7.5 Install Date Format Problem We are having an issue with our 7.5 upgrade. An example is as Hi, We are having an issue with our 7.5 upgrade. An example is as follows: In a Filter: DATE($Date Param$) returns '09/21/09' (where $Date Param$ = '21/09/2009 15:00:00') In an Active Link: DATE($Date Param$) returns --> '21/09/2009' (where $Date Param$ = '21/09/2009 15:00:00') i.e. same command returns different date formats. Anybody know why the Filter version of the command could possibly return the date in m/d/y format instead of the expected d/m/y as per the Active Link. Cheers, Paul Clements Senior Analyst/Programmer Applications & Business Solutions 112 Ingram Street Glasgow G1 1ET Phone: 0141 276 0938 Email: paul.cleme...@access.uk.com ***Disclaimer**** This e-mail and any attachments are for the intended addressee(s) only and may contain confidential and/or privileged material. If you are not a named addressee, do not use, retain or disclose such information. This email is not guaranteed to be free from viruses and does not bind Access in any contract or obligation. SERVICE GLASGOW LLP trading as ACCESS Registered in Scotland. No: SO301705 Registered Office:112 Ingram Street, Glasgow, G1 1ET _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"