Date Format from YYYYMMDDhhmmss to dd-MMM-yy

[Former Member]

Hi All,

I have a problem with the Date Format.

The out of the BAPI date format is like YYYYMMDDhhmmss and the output value is like 20,070,831,235,959. Now I want insert the date in to my Oracle database like dd-MM-yy.

Here is my xmlformat

datefromxmlformat(datetoxmlformat(Repeater_0.Output{/item/PERIOD_END},"yyyy-MM-dd

HH:mm:ss"),"dd-MMM-yy")

Can any one please correct this issue.

Thanks

Muvva

[Former Member · Accepted solution]

Hi Muvva,

If you want to convert a date from "yyyyMMddhhmmss' to 'dd-MM-yy' format, you may use the dateformat function. For example, the below will give you the result 30-08-08

dateformat("20080830121110","yyyyMMddhhmmss","dd-MM-yy")

In your case,

dateformat(Repeater_0.Output{/item/PERIOD_END},"yyyyMMddhhmmss","dd-MM-yy")

"dd-MMM-yy" will give you the result as "08-Aug-08", if you are looking for that format.

John

Edited by: John George on Aug 27, 2008 10:22 AM

[Former Member · Accepted solution]

Hello John,

Thanks for the reply.

I got the solution.