Hi Lisa The database reference guide has the information for going from EPOCH date to the date in a format you require (in 6.3 it was p.54 - see below signature) SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY HH24:MI:SS') + ((C<column_number> + <offset>)/(60*60*24)),'MM/DD/YYYY HH24:MI:SS') FROM T<table_number>;
Going the other way (subtract epoch from current stamp to get difference in seconds) select to_date('2008-07-16','yyyy-mm-dd') - to_date('1970-01-01','yyyy-mm-dd') from dual regards Dave Morgan Converting AR System dates to database dates AR System keeps track of the date and time to run escalations, stamps requests with the date and time they were submitted, and informs you when alerts were sent. To track the date and time, AR System uses a format that measures the number of seconds from January 1, 1970, 12:00 a.m. Greenwich Mean Time (GMT). While accurate, this format can be an awkward format to read. You might want to translate it to a format that your database can easily read. Each database requires different commands for the date and time conversion. The following procedures describe how you can use your database to convert the AR System date and time format. Note: In the SQL commands in the following procedures, the column number is referenced by <column_number>. Alternatively, you can provide the SQL view name of the column (the database name of the field as displayed in Remedy Administrator). " To convert the date and time format for a DB2 Universal database: " See your DB2 documentation for information about dateline arithmetic. " To convert the date and time format for an Informix database: 1 Using any front-end tool that allows direct access to an Informix-SQL database, log in as the root user. 2 Type the following command: % select (extend((extend(datetime(1970-1-1) year to day, year to hour) - interval(<offset_hours>) hour to hour), year to second) + C<column_number> units second) from T<table_number> where, <column_number> is the number of the column for the date and time field, <table_number> is the number of the form table, and <offset_hours> is a positive or negative number representing the number of hours later or earlier than GMT. If the date is greater than 09/10/2001, you will receive an error. To avoid an error, you can display minutes instead of seconds by using the following command: % select (extend((extend(datetime(1970-1-1) year to day, year to hour) - interval(<offset_hours>) hour to hour), year to minute) +(C<column_number>/60) units minute) from T<table_number> See the Informix Guide to SQL: Reference and Syntax manaul for information about the datetime, extend, and interval functions. " To convert the date and time format for an Oracle database: 1 Using any front-end tool that enables direct access to an Oracle SQL database, log in as a user with write access to the AR System tables. 2 Type the following command: % SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY HH24:MI:SS') + ((C<column_number> + <offset>)/(60*60*24)), 'MM/DD/YYYY HH24:MI:SS') FROM T<table_number>; where, <column_number> is the number of the column for the date and time field, <table_number> is the number of the form table, and <offset> is a positive or negative number representing the number of seconds later or earlier than GMT. See the your Oracle documentation for information about the TO_DATE and TO_CHAR functions. " To convert the date and time format for a Sybase or Microsoft SQL Server database: 1 Using any front-end tool that enables direct access to a Sybase or Microsoft SQL Server database, log in as a user who has write access to the AR System tables. 2 Type the following command: % select dateadd(second, C<column_number> + <offset>, "Jan 1, 1970") from T<table_number> where, <column_number> is the number of the column for the date and time field, <table_number> is the number of the form table, and <offset> is a positive or negative number representing the number of seconds later or earlier than GMT. 3 Optionally, you could format the date field by using the convert function. There are 12 different formats from which you can choose. See your Sybase documentation. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: 18 August 2009 18:24 To: arslist@ARSLIST.ORG Subject: Re: Date Time Conversion Issue in Remedy --_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I think this is the function to convert FROM Epoch to a readable date/time = format. I need the other way around... Thanks! Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslis= T.ORG] On Behalf Of Cesaro, Tony M[EQ] Sent: Tuesday, August 18, 2009 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: Date Time Conversion Issue in Remedy ** Lisa, We ended up writing an Oracle function to generate the conversion for us. = I have included the SQL source below. You'll obviously want to change your= time zone and input date format accordingly. create or replace FUNCTION GETDATE (a_number number) RETURN Date IS date_x date; BEGIN if a_number is null then return null; else date_x :=3D new_time(TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYYHH24:MI= :SS') + (a_number/86400),'GMT','EDT'); end if; RETURN(date_x); END GetDate; Regards, Tony Cesaro From: Action Request System discussion list(ARSList) [mailto:arsl...@arslis= T.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, August 18, 2009 12:52 To: arslist@ARSLIST.ORG Subject: Re: Date Time Conversion Issue in Remedy ** I'm having a similar issues (details are a little bit different), but how d= o you convert a MM/DD/YYYY HH:MM:SS to epoch time. We are using Windows 20= 03, Oracle 10, ARS 7.0.1.... I've seen lots of info about converting Epoch to a readable date format, bu= t not the other way around.... Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslis= T.ORG] On Behalf Of Robert Halstead Sent: Tuesday, August 04, 2009 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: Date Time Conversion Issue in Remedy ** In the database, Remedy stores all date's in integer format (epoch unix = time). Perhaps this is your issue? If you are putting these records direc= tly into the database without going through remedy then you need to use epo= ch time. If you are going through remedy, then I believe its the locale of= the server but not sure. (MM/DD/YYYY HH:MM:SS) Hopefully this helps? On Tue, Aug 4, 2009 at 11:31 AM, AMEY BHOSALE <ameyb...@gmail.com<mailto:am= eyb...@gmail.com>> wrote: ** Hi All, I have an issue in conversion of Date Time Format which is retrieved by cal= ling a stored Procedure from other Database into Remedy So the workflow is there an Filter which has Set Field Action consisting of= Webservice where the input and Output Parameters are mapped.So this webser= vice runs on the XMLGATEWAY calling the stored procedure. There is a form in Remedy which will store the details retrieved from store= d procedure.The fields in the form are mapped in Xmlgateway Template (Creat= e) and Template (Query). The Template(Create) will create the record in the Remedy Form with the Out= put recieved from the Template(Query) which contains the stored procedure d= etails. So there are there date time fields which are returned by stored procedure = having the formats as below : - Two Date Time fields have format as :- MM/dd/yyyy hh:mm:ss for e.g 4/17/200= 8 12:00:00 One Date Time field has format as :- yyyy/MM/dd hh:mm:ss for e.g 2008/ 4= /17 12:00:00 So in the Create Template of Xmlgateway i specified the above formats but w= hen the record is created in Remedy the other values are captured but the d= ate time format fields the value is blank. When i checked Catalina.out log file found that it is not able to convert t= his date format into Remedy. So can anyone let me know what format of date time needs to be specified in= Create Template of Xmlgateway ? Regards, Amey Bhosale _Platinum Sponsor: rmisoluti...@verizon.net<mailto:rmisoluti...@verizon.net= > ARSlist: "Where the Answers Are"_ -- "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts= on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed." Bob Halstead _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are= "_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are= "_ _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" --_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns:v =3D "urn:schemas-microsoft-com:vml" xmlns:o =3D=20 "urn:schemas-microsoft-com:office:office" xmlns:w =3D=20 "urn:schemas-microsoft-com:office:word" xmlns:m =3D=20 "http://schemas.microsoft.com/office/2004/12/omml"><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.6000.16890" name=3DGENERATOR></HEAD> <BODY lang=3DEN-US vLink=3Dpurple link=3Dblue> <DIV dir=3Dltr align=3Dleft><SPAN class=3D051072317-18082009><FONT face=3DA= rial=20 color=3D#000080 size=3D2>I think this is the function to convert FROM Epoch= to a=20 readable date/time format. I need the other way=20 around...</FONT></SPAN></DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D051072317-18082009><FONT face=3DA= rial=20 color=3D#000080 size=3D2><BR>Thanks!</FONT></SPAN></DIV> <DIV> </DIV><!-- Converted from text/rtf format --> <P><SPAN lang=3Den-us><FONT face=3DArial color=3D#000080 size=3D2>Lisa</FON= T></SPAN>=20 </P> <DIV> </DIV><BR> <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft> <HR tabIndex=3D-1> <FONT face=3DTahoma size=3D2><B>From:</B> Action Request System discussion= =20 list(ARSList) [mailto:arsl...@arslist.org] <B>On Behalf Of </B>Cesaro, Tony= =20 M[EQ]<BR><B>Sent:</B> Tuesday, August 18, 2009 1:01 PM<BR><B>To:</B>=20 arslist@ARSLIST.ORG<BR><B>Subject:</B> Re: Date Time Conversion Issue in=20 Remedy<BR></FONT><BR></DIV> <DIV></DIV>**=20 <META content=3D"Microsoft Word 12 (filtered medium)" name=3DGenerator><!--= [if !mso]> <STYLE>v\:* { BEHAVIOR: url(#default#VML) } o\:* { BEHAVIOR: url(#default#VML) } w\:* { BEHAVIOR: url(#default#VML) } .shape { BEHAVIOR: url(#default#VML) } </STYLE> <![endif]--> <STYLE>@font-face { font-family: Calibri; } @font-face { font-family: Tahoma; } @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","seri= f" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","seri= f" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","seri= f" } A:link { COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99 } A:visited { COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99 } P { FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times = New Roman","serif"; mso-style-priority: 99; mso-margin-top-alt: auto; mso-m= argin-bottom-alt: auto } SPAN.EmailStyle18 { COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: perso= nal-reply } .MsoChpDefault { FONT-SIZE: 10pt; mso-style-type: export-only } DIV.Section1 { page: Section1 } </STYLE> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> <DIV class=3DSection1> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-seri= f'">Lisa,<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-seri= f'"><o:p> </o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-seri= f'">We=20 ended up writing an Oracle function to generate the conversion for us. = ; I=20 have included the SQL source below. You’ll obviously want to ch= ange your=20 time zone and input date format accordingly.<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-seri= f'"><o:p> </o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'">creat= e or=20 replace FUNCTION GETDATE (a_number number)<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'"> = ;RETURN=20 Date IS<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'"> = ; =20 date_x date;<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'"><o:p>= </o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'">BEGIN= <o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'"> = ; if=20 a_number is null then<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'"> = ; =20 return null;<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'"> = ;=20 else<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'"> = ; =20 date_x :=3D new_time(TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYYHH24:MI:SS')= +=20 (a_number/86400),'GMT','EDT');<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'"> = ; end=20 if;<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'">RETUR= N(date_x);<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Courier New'">END=20 GetDate;<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-seri= f'"><o:p> </o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-seri= f'">Regards,<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-seri= f'"><o:p> </o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-seri= f'">Tony=20 Cesaro<o:p></o:p></SPAN></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-seri= f'"><o:p> </o:p></SPAN></P> <DIV=20 style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df= 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium non= e; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none"> <P class=3DMsoNormal><B><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN><= /B><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> Action Reque= st=20 System discussion list(ARSList) [mailto:arsl...@arslist.org] <B>On Behalf O= f=20 </B>Kemes, Lisa<BR><B>Sent:</B> Tuesday, August 18, 2009 12:52<BR><B>To:</B= >=20 arslist@ARSLIST.ORG<BR><B>Subject:</B> Re: Date Time Conversion Issue in=20 Remedy<o:p></o:p></SPAN></P></DIV> <P class=3DMsoNormal><o:p> </o:p></P> <P class=3DMsoNormal>** <o:p></o:p></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'">I= 'm=20 having a similar issues (details are a little bit different), but how do yo= u=20 convert a MM/DD/YYYY HH:MM:SS to epoch time. We are using Windows 200= 3,=20 Oracle 10, ARS 7.0.1....</SPAN><o:p></o:p></P> <P class=3DMsoNormal> <o:p></o:p></P> <P class=3DMsoNormal><SPAN=20 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'">I= 've=20 seen lots of info about converting Epoch to a readable date format, but not= the=20 other way around....</SPAN><o:p></o:p></P> <DIV> <P class=3DMsoNormal> <o:p></o:p></P></DIV> <P><SPAN=20 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'">L= isa</SPAN>=20 <o:p></o:p></P> <DIV> <P class=3DMsoNormal> <o:p></o:p></P></DIV> <P class=3DMsoNormal><o:p> </o:p></P> <DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" align=3Dcenter> <HR align=3Dcenter width=3D"100%" SIZE=3D2> </DIV> <P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><B><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN><= /B><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> Action Reque= st=20 System discussion list(ARSList) [mailto:arsl...@arslist.org] <B>On Behalf O= f=20 </B>Robert Halstead<BR><B>Sent:</B> Tuesday, August 04, 2009 4:24=20 PM<BR><B>To:</B> arslist@ARSLIST.ORG<BR><B>Subject:</B> Re: Date Time Conve= rsion=20 Issue in Remedy</SPAN><o:p></o:p></P> <P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt">** In the database, Reme= dy stores=20 all date's in integer format (epoch unix time). Perhaps this is your= =20 issue? If you are putting these records directly into the database wi= thout=20 going through remedy then you need to use epoch time. If you are goin= g=20 through remedy, then I believe its the locale of the server but not sure.&n= bsp;=20 (MM/DD/YYYY HH:MM:SS)<BR><BR>Hopefully this helps?<o:p></o:p></P> <DIV> <P class=3DMsoNormal>On Tue, Aug 4, 2009 at 11:31 AM, AMEY BHOSALE <<A=20 href=3D"mailto:ameyb...@gmail.com">ameyb...@gmail.com</A>>=20 wrote:<o:p></o:p></P> <P class=3DMsoNormal>** Hi All, <o:p></o:p></P> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>I have an issue in conversion of Date Time Format whic= h is=20 retrieved by calling a stored Procedure from other Database into=20 Remedy<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>So the workflow is there an Filter which has Set Field= Action=20 consisting of Webservice where the input and Output Parameters are mapped.S= o=20 this webservice runs on the XMLGATEWAY calling the stored=20 procedure.<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>There is a form in Remedy which will store the details= =20 retrieved from stored procedure.The fields in the form are mapped in Xmlgat= eway=20 Template (Create) and Template (Query).<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>The Template(Create) will create the record in the Rem= edy=20 Form with the Output recieved from the Template(Query) which contains the s= tored=20 procedure details.<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>So there are there date time fields which are returned= by=20 stored procedure having the formats as below : -<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>Two Date Time fields have format as :- MM/dd/yyyy hh:m= m:ss=20 for e.g 4/17/2008 12:00:00<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal>One Date Time field has format as :- yyyy= /MM/dd=20 hh:mm:ss for e.g 2008/ 4/17 12:00:00<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>So in the Create Template of Xmlgateway i specified th= e above=20 formats but when the record is created in Remedy the other values are captu= red=20 but the date time format fields the value is blank.<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>When i checked Catalina.out log file found that it is = not=20 able to convert this date format into Remedy.<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>So can anyone let me know what format of date time nee= ds to=20 be specified in Create Template of Xmlgateway ?<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>Regards,<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal>Amey Bhosale<o:p></o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <DIV> <P class=3DMsoNormal><o:p> </o:p></P></DIV> <P class=3DMsoNormal>_Platinum Sponsor: <A href=3D"mailto:rmisoluti...@veri= zon.net"=20 target=3D_blank>rmisoluti...@verizon.net</A> ARSlist: "Where the Answers Ar= e"_=20 <o:p></o:p></P></DIV> <P class=3DMsoNormal><BR><BR clear=3Dall><BR>-- <BR>"A fool acts, regardles= s;=20 knowing well that he is wrong. The ignoramus acts on only what he knows, bu= t all=20 that he knows.<BR>The ignoramus may be saved, but the fool knows that he is= =20 doomed."<BR><BR>Bob Halstead<BR>_Platinum Sponsor: rmisoluti...@verizon.net= =20 ARSlist: "Where the Answers Are"_ <o:p></o:p></P> <P class=3DMsoNormal>_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "= Where=20 the Answers Are"_ <o:p></o:p></P></DIV>_Platinum Sponsor:=20 rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ </BODY></HTML> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ --_000_46CDC1E68702E54387E9EAEDC0A02CA207C87BF0C5us194mx002tyc_-- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"