‎2007 Jun 19 5:22 AM
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
‎2007 Jun 19 5:26 AM
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
‎2007 Jun 19 5:24 AM
‎2007 Jun 19 5:26 AM
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
‎2007 Jun 19 5:27 AM
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.
‎2007 Jun 19 5:32 AM
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