Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Convert date into exponential format

Former Member
0 Kudos
290

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.

2 REPLIES 2

Former Member
0 Kudos
91

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.

0 Kudos
91

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.