topic Re: changing the date format. in Application Development and Automation Discussions

changing the date format.

Former Member — Tue, 19 Jun 2007 04:22:44 GMT

hi experts,

i have the internal table in my report which has one field i.e date field of type datum.

now i am down loading the output to local file using gui_download.

now i want the date format need to be formated to DD/MM/YYYY which is of 10 charcters in the local file.

how to go about this?

thanks

Shyam

Former Member — Tue, 19 Jun 2007 04:24:33 GMT

use EDIT MASK option

Former Member — Tue, 19 Jun 2007 04:26:10 GMT

Hi,

Try this..



DATA: V_DATE TYPE SYDATUM.
DATA: V_OUTPUT(10).

V_DATE = SY-DATUM.

WRITE V_DATE TO V_OUTPUT DD/MM/YYYY.

WRITE: / V_OUTPUT.

Thanks

Naren

Former Member — Tue, 19 Jun 2007 04:27:54 GMT

Hi Shyam,

The input by the user depends upon the settings in the User profile :

SAP Screen --> Menu --> System --> User Profile --> Own Data --> Defaults -->

Date Format .

The user can use any of the format.

Ask the user to set the Date format as ddmmyyyy.

If not you can do a validation and if the user enters a date in the format other than u desired then u can show a message.

Thanks,

reward If Helpful.

Former Member — Tue, 19 Jun 2007 04:32:52 GMT

Hi,

Use FM CONVERSION_EXIT_ALPHA_OUTPUT and pass the date field to it.

it will convert the date into required

or use CONVERSION_EXIT_PDATE_OUTPUT

Regards

Shiva