How to display date field in Webdynpro ALV in format 'DD/MM/YYYY'?

[former_member810730]

Hi experts,

I am not getting displayed the date field in ALV in the format 'DD/MM/YYYY' if it is different than my user setting's format (DD.MM.YYYY).

I could not find the conversion routine for this. Is it possible to write customer conversion routine?

I have to use DATE field, otherwise if I display this format in CHAR10 field , sorting in ALV does not work for this field.

PLEASE ANY HELP!

Kind regards,

Syed

[former_member211591]

additionally:

probably sorting in the ALV is based on the internal format YYYYMMDD (please check thats correct by comparing the dates in your application).

I don't know if it is possible to sort by the displayed format DD/MM/YYYY; I'am afraid not.

Regards

ismail

[former_member810730]

Thanks Ismail for your efforts,

I had managed to display the date in DD/MM/YYYY format in alv .....but the sort is not working correctly as it works for YYYYMMDD.

Thanks

Syed

[former_member211591]

Hi Syed,

the standard conversion exit converts the date using the user setting's format.

But you can create a datatype (with own domain) with your own conversion exit.

create your own conversion exit for output with:

DATA: D3DAT(10) VALUE '__/__/____'.
*=*
   CLEAR OUTPUT.
   MOVE INPUT(4)    TO D3DAT+6(4).
   MOVE INPUT+4(2)  TO D3DAT+3(2).
   MOVE INPUT+6(2)  TO D3DAT(2).
*=*
   OUTPUT = D3DAT.

and vice versa for conversion exit input.

You can compare with these conversion exits:

CONVERSION_EXIT_D3DAT_OUTPUT

CONVERSION_EXIT_D3DAT_INPUT

Regards

ismail