topic Re: Convert date into exponential format in Application Development and Automation Discussions

Convert date into exponential format

Former Member — Thu, 26 Jun 2008 18:01:58 GMT

Hi,

I have a date & I want to convert into exponential format & how do I convert this exponential format back to the date. I need to have flexibility in customizing the date as per the need. How can I do this?

Example:

let's try to convert 10/12/2007 into exponential format. After converting into exponential form, I want to convert it back to 10/12/2007. At the same time, I want to have the flexiblity of showing the date as 12/10/2007 .

Hope it's clear. How do i do this?

Full points will be awarded to the first correct complete answer.

Looking forward for your replies. Thank you.

Re: Convert date into exponential format

Former Member — Thu, 26 Jun 2008 18:16:00 GMT

DATE_CONV_EXT_TO_INT will convert the date given by the external system or user input in date field in screens to ur system date format.

CONVERT_DATE_TO_EXTERNAL will convert the internal date format to ur screen date field format.

Re: Convert date into exponential format

Former Member — Thu, 26 Jun 2008 18:22:00 GMT

Hi,

Thank you for your fast reply. Are they functional modules? How do I use them? I have to convert the date into exponential format (example: 2.0071012000000000E07) & the exponential form 2.0071012000000000E07 to the date it relates to. Can you please show me how to do that?

Looking forward for your reply. Thank you.