As others have stated, the system is doing a conversion from a character field to a date field. It has to assume the format of the character field is the format it is using.
Your system must have the date format for the server set to a different format than the data is flowing into the system. This is a MAJOR challenge with dates in general -- what is your context. For example, if you just have 5/10/12 as the value, what date is it? The answer is really that it is NOT ABLE TO BE DETERMINED with certainty. You can guess at the meaning based on context and ASSUME that the date is formatted as you are going to interpret it -- but that is all you can do, make a guess. This is why we store all dates in the AR System as an integer. There is no issue with interpretation and the value can be "reinterpreted" in a character manner as the reader wants it interpreted so that they are making the right assumptions about its format. Since you are getting dates in a different format than what the system is processing them in, you need to do one of the following: 1) Get the source to change the formatting -- probably not possible 2) Get the AR System to change the formatting it is expecting. This changes the format of displayed dates everywhere so is likely not what you want as you seem to want the AR System server formatting not the formatting of the data coming in 3) Manipulate the date in the character field before assigning to the date (as has been discussed) to change the order of things and get it into the order you want. BUT, be careful because THIS data source has the data in the format you need to switch the order. Other instances may not have it in a different order so your switching would break things in those cases. Something to be aware of. I hope this helps, Doug Mueller -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, March 26, 2013 7:07 AM To: arslist@ARSLIST.ORG Subject: Re: Pushing data from character field to date field It sounds like the date format in your character field does not match the format of your date field. Your third party app is using mm/dd/yyyy and your ARS system is using dd/mm/yyyy Misi's set fields should take care of the issue, although you probably should make sure all systems agree on the same definition of fields when integrating applications. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick Sent: Monday, March 25, 2013 7:00 PM To: arslist@ARSLIST.ORG Subject: Pushing data from character field to date field Hi all, We have third party application were the data comes to remedy stating form and the date/time will be captured in character field. When the datas are moved to main form the date are showing different. Ex. Staging form Character field . Date/Time field - mm/dd/yyyy When the data is moved to main form it take dd as mm and mm as dd. Help me on this Our server timing is in Australia time zone Sent from my iPhone _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
