topic Re: change date type in Application Development and Automation Discussions

change date type

Former Member — Thu, 16 Aug 2007 09:50:03 GMT

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

Re: change date type

Former Member — Thu, 16 Aug 2007 09:53:14 GMT

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

S@meer

Re: change date type

former_member194669 — Thu, 16 Aug 2007 09:58:19 GMT

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

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

Re: change date type

Former Member — Thu, 16 Aug 2007 10:11:38 GMT

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

Re: change date type

Former Member — Thu, 16 Aug 2007 10:27:57 GMT

Hi..

that date format is inverted date format..

Regards,

Aparna

Re: change date type

Former Member — Thu, 16 Aug 2007 10:28:53 GMT

Use the following code :

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

Regards,

Aparna

Re: change date type

Former Member — Thu, 16 Aug 2007 10:46:24 GMT

today is 1600807...im giving this date

in the table its showing 79929183

so is it inverted????

Re: change date type

Former Member — Thu, 16 Aug 2007 11:04:02 GMT

hi Aparna

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

now what to do??

Re: change date type

Former Member — Thu, 16 Aug 2007 11:15:06 GMT

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

Re: change date type

Former Member — Thu, 16 Aug 2007 11:16:07 GMT

make use of this FM

CONVERSION_EXIT_INVDT_OUTPUT

Regards

Peram

Re: change date type

Former Member — Thu, 16 Aug 2007 11:23:59 GMT

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

Re: change date type

Former Member — Thu, 16 Aug 2007 11:52:53 GMT

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

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

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

now i have to convert that 79929183 to 1600807 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 79929183 what type of format is this???

Re: change date type

Former Member — Fri, 17 Aug 2007 05:35:15 GMT

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

Regards,

Aparna

Re: change date type

Former Member — Sat, 18 Aug 2007 06:33:15 GMT

problem solved

Re: change date type

Former Member — Mon, 20 Aug 2007 11:57:50 GMT

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

Regards,

Aparna