change date type

[Former Member]

My table is "tcurr"

and my field is "gdatu" which contains date but in a different format. I have to change this date format to //---- for posting in a BDC table which only alows //---- format. if i have to use

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL/EXTERNAL' then how to use?

plz help

[Former Member]

USE write to ........... using edit mask STATEMENT FOR FORMATTING DATES.

S@meer

[Former Member]

plz check once the field in taht tabel then give suggession....its very different from date field

[former_member194669]

Hi,

external_date = '2006.12.01'.

CALL FUNCTION 'KCD_EXCEL_DATE_CONVERT'

EXPORTING

EXCEL_DATE = external_date

DATE_FORMAT = 'JMT' "(T) Day,(M) Month,(J) Year

IMPORTING

SAP_DATE = sap_date

or

You have to do settings in SU3(T.CODE). In SU3 goto defaults there you find Date Format. try to keep your settings and save it. Your BDC will work.

aRs

[Former Member]

Hi..

that date format is inverted date format..

Regards,

Aparna

[Former Member]

Use the following code :

CONVERT INVERTED-DATE <d1> INTO DATE <d2>.

Regards,

Aparna

[Former Member]

today is <b>1600807</b>...im giving this date

in the table its showing <b>79929183</b>

so is it inverted????

[Former Member]

hi Aparna

i tried with this CONVERT but it is not working..

now what to do??

[Former Member]

hi,

use this function to get the desired output 'CONVERSION_EXIT_INVDT_OUTPUT' where your input is Gdatu and output is correct date.

regards

Abhilasha Gupta

[Former Member]

make use of this FM

CONVERSION_EXIT_INVDT_OUTPUT

Regards

Peram

[Former Member]

Hi,

Use this function module before applying the BDC process, CONVERSION_EXIT_PDATE_OUTPUT, this will definitly serve the perpose, reward if found usefull.

Regards,

Rama Murthy.P

[Former Member]

thanks 4 your all sugessions.....but u can get my problem properly or i cant expline u properly....

see, Today is <b>1600807</b>the table TCURR which has a field <b>gdatu</b> is taking this date like <b>79929183</b>.

So this format is neither inverted nor any other fornmat....

now i have to convert that <b>79929183</b> to <b>1600807</b> for BDC.

the data type for date i have to give TCURR-GDATU_INV.....if differ from that i will give, in the selet statement it will not fatch data from the DB table....

so <b>79929183</b> what type of format is this???

[Former Member]

subtract the GDATU date from 99999999... this will give you the date in 0calday format..

Regards,

Aparna

[Former Member]

problem solved

[Former Member]

If the problem is solved assign points to the useful posts and close the thread,,

Regards,

Aparna