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"