Date format

[rohit_goel]

Hi All,

I am facing an issue in SAP xMII BLS related to Date comaprison, i want to convert date into YYYYMMDD format from following format 2009-01-05T00:00:00 .

as i have already tried dateformat(datetime, fromformat, toformat) funcation its not working .

thanks in advance

Regards,

Rohit

[Former Member]

Hi Rohit ,

Try this way.

datefromxmlformat(datetoxmlformat(Your variable,"yyyy-MM-dd"),"dd-MMM-yy")

Thanks

Muvva

[Former Member]

Take note that 'hh' indicates the 12 hour clock and 'HH' indicates the 24 hour clock.

[Former Member]

Rohit,

Don't forget to add "HH:mm:ss" to Pedro's line of code if you want to display the time exactly as your request. For future reference, you can search the MII Help for "Expression Editor Built-In Functions" for an explanation of all functions used in the Expression window of the Link Editor.

Regards,

Kevin

[Former Member]

Rohit,

your source date is XMLFormat, so you need to use the following function for converting:

datefromxmlformat(yourVariable, "yyyyMMdd")

Regards

Pedro