How convert date/time from xml in xdp(Designer)?

Advertisement
October 11

Hi, i want to convert date/time format from xml in Designer, date/time value in xml is NOT in common format YYYY-MM-DD (if is in a common format i can do this with pattern)
I have a "DateTime" Field in Xdp can get from Xml date and time:
In XML <DateTime>DD-MM-YYYY</DateTime> i want to convert in XDP in DateTime Field in "DD-April-YYYY"
Can i do this?

Advertisement

Replay

You can do this way..
Bind the date field to your XML tag.
Set the display pattern for the date field.
In the initialize event of the date field place the following code.
Set JavaScript as language.
var dtStr = this.rawValue;
var pos1=dtStr.indexOf("-");
var pos2=dtStr.indexOf("-",pos1+1);
var strMonth=dtStr.substring(0,pos1);
var strDay=dtStr.substring(pos1+1,pos2);
var strYear=dtStr.substring(pos2+1);
//Assign the formatted value to the Date field.
this.rawValue = strYear + "-" + strMonth + "-" + strDay;
Thanks
Srini

View 3 Replies

FUNCTION MODULE TO CONVERT DATE / TIME INTO WORDS.

November 30

HI EXPERTS,      FUNCTION MODULE TO CONVERT DATE / TIME INTO WORDS. PLS DO HELP.....Hiii gita we have another FM SPELL_AMOUNT regards JaipalRead other 3 answers

View All Replies

How to convert date-time according to the Time Zone the client

October 11

Urgent! Help wanted! I extract a date-time field (which is GMT time) from the central database but I need to convert it accordding to the TimeZone of the user and also the so-called winter time and summer time in the local. Any one has any good solut

View All Replies

Apply spry functions on data uploaded from xml?

November 30

Hi, I am trying to "simplify" my personal pages so I have only 1 html page and everything else is taken from xml through spry framework (guys ... I love it .. super work) But currently I am stuck on one issue: Step 1 I replace the html parts -&g

View All Replies

How to get Time from Different Work Station on the Network

November 30

Hi, How do I get time from different work station on the network using its ip:port etc. Lets say, my main server-side Java application is running on a work station 123.12.123.1:1527, the client-side applications are accessing it using above IP. what

View All Replies

How to subtract Time from Sysdate

November 30

Hello, I want to subtract time from sysdate and get the sysdate with time. Example : = (Sysdate with time)03-mar-2002 16:40:55 - 8 (hours). The result should be like :03-mar-2002 08:40:55 How to write a query for this?. Please let me know as soon as

View All Replies

How to remove namespace from xml in ALSB?

November 30

I have a xquery transformation which works for data without namespace. But the data coming from source system has namespace details in it. Is there a way to strip the xml of namespace details from xml before passing it to xquery transformation?Hi sil

View All Replies

How to set defaultPanel from XML

October 11

Hi Everyone, I'm using Spry Accordion as a menu and im loading the data from an xml file, the problem is if I try to set the defaultPanel to anything else besides "0" like the following <script type="text/javascript"> var Accordi

View All Replies

How to parse contents from XML file in Java

October 11

Hi All, I have a scenario like this . I have one xml file with key value pairs of ( name , URL ) . I have retrieved contents from XML file , now I want to parse these contents and store in a bean object. How to parse Contents of XML file?? Thanks in

View All Replies

Data Import from XML Format file

October 11

I want to import data  from XML file format.Can i do it ? If yes then please give me more details in the step.Pl read the below link. It will be helpful. SAP Business One Application JeyakanthanRead other 2 answers

View All Replies

Convert Date format from YYYYMMDD to MM/DD/YYYY --issue with Mapping

October 11

Hi All , I have IDOC(DESADV.DELVRY03-> file ) scenario which i am working on . While debugging noticed that the field : E1EDT13\NATNZ -Data Transformation(from yyyymmdd to mm/dd/yyyy)-Target .This works But say if IDOC doesn't pass any value (For Goo

View All Replies

How to convert Date format from yyyy mm dd   to   dd mmm yyyy in ADF

October 11

Hi, I have Date Format in Data Base as yyyy mm dd, but in the UI I want to display the format as dd mmm yyyy, which code I have to write to get the required format in JDev 11.1.2.3Hi, Use converter : &lt;af:convertDateTime&gt; See also : convertDa

View All Replies

How convert date with different timezone?

November 30

HI, My problem is pretty simple. I have one Date and given another time zone (as a string), I want to have another date object with a different time zone. I used jodaTime. The code is as follows: DateTimeZone zone = DateTimeZone.forID("US/Eastern&quo

View All Replies

How to hide elements from xml file when dumping to JTree?

October 11

Hi everybody, I got a XML file similar to this one: <Dios> <Adan> <Hijos> <Vivos> <Nombre>Isaac</Nombre> <ColorOjos>Verdes</ColorOjos> <ColorPelo>Casta�o</ColorPelo> <Nombre>Paris</Nombr

View All Replies

How to retrieve information from XML using servlets

October 11

Hi I have a scenario like this File-->XI-->J2ee application(HTTP Receiver adapter) I want to know how XI sends xml file as a query string file name? What ever may be the case i just need to retrieve the information from Request object and display th

View All Replies

How to generate WSDL from XML Schema?

November 30

What are reasonable strategies, both direct and indirect, to generate a WSDL from an XML Schema describing our messages? I'd prefer a more direct route, but I'd like to understand the various choices. We're currently using WLP8.1SP2.Hi David, There i

View All Replies

Strange date/time in App. Builder

November 30

I just noticed that the executable file that was created by using App. Builder always showed differenct date/time from the current date/time. Anyone could give me an idea what is wrong? How can I set it to the correct date/time? Thank you in advance

View All Replies

Date/Time erros when working with Database Connectivity toolkit

November 30

Hi!, We are observing errors with date/time when working with LV. The error occurs when the system datetime format is set such that day precedes month (e.g. dd/mm/yyyy). Our VI uses LV 7.1, Database Connectivity 1.0 and SQL Server 2000 on a Win2000 m

View All Replies

Printing information (date+time) of an order

November 30

Hi experts, Do you know where printing information (date + time) of an order is stored? Does SAP store also a re-printing information? Via configuration OIOE, it triggers the printing information in table JCDS , but in case of re-printing, SAP does n

View All Replies

Is there any function module to convert date format?

November 30

Is there any function module to convert date format from mm/dd/yyyy to dd.mm.yyyy or sy-datum?Hi, wirte statement converts any date fomat in system date fromat     WRITE w_DateTO w_date_sys. Regards, SriramRead other 4 answers

View All Replies

Tags:

  1. arp mac aging best practices
  2. macbook pro periodic sound
  3. error: err_wis_30270 how to restore file
  4. Neha jpx pothos
  5. sap note 1113277
  6. RBKP RBSTAT Update BAPI
  7. 30LF
  8. OB76
  9. tongueri1
  10. DAQmx_Val_ChanPerLine
Copyrights 2019 Fcffair BigData Resource, All rights reserved