Hi Kali I presume that you are using the WUT, I have experienced similar oddities with it, regarding number formatting. Have a look at your regional settings on the client machine, that is probably the culprit.
with regards, Jonas Stumph Stevnsvig Remedy Developer BEC Competence Centre Phone (+45) 46 38 20 08 Mobile (+45) 61 56 20 08 [email protected] [email protected] ________________________________ Fra: Action Request System discussion list(ARSList) [mailto:[email protected]] På vegne af Kali Obsum Sendt: 2. september 2009 08:29 Til: [email protected] Emne: DATE function - Server Date Format ** Hi, We have a FILTER action that uses the DATE function to push values from a character field into a date/time field. ex: Field1 = character field, Field2 = date/time field Field2=DATE($Field1$) The string value of Field1 is in format: MM/DD/YYYY. Value of Field2 becomes 01/01/1970 10:00:01 AM Does this have anything to do with the Server Date Format of Remedy? If yes, how do I check what's the server date format being used? Also, the behavior is different in production env and in UAT env. In UAT, even if the format of Field1 is MM/DD/YYYY, the filter is able to convert it properly to the correct date. I'm not sure but I think the server date formats are the same in prod and UAT. If this is the case, then there are other factors that are causing the date to not be converted properly? Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
