topic Re: About date format in Application Development and Automation Discussions

About date format

former_member204025 — Fri, 27 Aug 2010 18:00:58 GMT

Hi guys!

I hope you can help me with this.

I'm working with an update on TCURR table, the fact is I prepared a dynpro with all the fields in order to enter the information for every field, and when the user enter de field GDATU, it saves the date in a correct format. MM/DD/YYYY. But when I see the /table TCURR, If I enter a date it appears in a strange format, If I double clic on that line, I see the right date.

My program do this:

1. Shows an ALV with all tcurr fields in which kurst = N.

2. If I select a line, I see a dynpro with all the values for that line, I can edit it and update the information. Once I do that, I coome back to the ALV with the updated table.

3. If I select one line again, I see the strange format in date.

Could you please help me with that field? I don't know what I should do in order to show it in a right way.

Thanks!

Gaby

Re: About date format

Former Member — Fri, 27 Aug 2010 18:08:49 GMT

Hi I believe its related to conversion exit, try using any of the below which suits your requirement.

CONVERSION_EXIT_IDATE_INPUT External date INPUT conversion exit (e.g. 01JAN1994)

CONVERSION_EXIT_IDATE_OUTPUT External date OUTPUT conversion exit (e.g. 01JAN1994)

CONVERSION_EXIT_LDATE_OUTPUT Internal date OUTPUT conversion exit (e.g. YYYYMMDD)

CONVERSION_EXIT_SDATE_INPUT External date (e.g. 01.JAN.1994) INPUT conversion exit

CONVERSION_EXIT_SDATE_OUTPUT Internal date OUTPUT conversion exit (e.g. YYYYMMDD)

Re: About date format

Former Member — Fri, 27 Aug 2010 18:31:22 GMT

The date is stored as 9's complement. Run it through conversion exits:

CONVERSION_EXIT_INVDT_INPUT

CONVERSION_EXIT_INVDT_OUTPUT

Rob

Re: About date format

Former Member — Sat, 28 Aug 2010 04:30:30 GMT

Hi,

That is the characterstic of currency and exchange rates tables TCurr and CURX .

i think the strange date format u might be seeing is also a date value but it gets stored as

given date = 99999999 - given date = 7xxxxxxx as an example .

note that it follows yyyymmdd format .

so As Rob suggested try to use the conversion routine .

BR,

Vijay.

Re: About date format

Former Member — Sat, 28 Aug 2010 04:43:01 GMT

Hi Gaby,

go ti table TCURR in se11~~>TCURR table~~>select dataelemet for GDATU and double click

and go to domain and see the conversion routine attached .

CONVERSION_EXIT_INVDT_INPUT "Select query format or internal format

CONVERSION_EXIT_INVDT_OUTPUT "Output Format ot Display format normal date as user defaults.

Prabhudas