Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

change date type

former_member198275
Active Contributor
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

14 REPLIES 14

Former Member
0 Kudos

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

S@meer

0 Kudos

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

former_member194669
Active Contributor
0 Kudos

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
0 Kudos

Hi..

that date format is inverted date format..

Regards,

Aparna

Former Member
0 Kudos

Use the following code :

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

Regards,

Aparna

0 Kudos

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

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

so is it inverted????

0 Kudos

hi Aparna

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

now what to do??

Former Member
0 Kudos

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
0 Kudos

make use of this FM

CONVERSION_EXIT_INVDT_OUTPUT

Regards

Peram

Former Member
0 Kudos

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

0 Kudos

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???

0 Kudos

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

Regards,

Aparna

former_member198275
Active Contributor
0 Kudos

problem solved

0 Kudos

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

Regards,

Aparna