topic Problem with date format in Application Development and Automation Discussions

Problem with date format

Former Member — Tue, 20 Mar 2007 05:06:55 GMT

Hi Guys,

I have requirement where i've to upload date in format ddmmyyyy thru a BDC. The date what i get may be in format ddmmyyyy or yyyymmdd . So, i've to change dynamically the date format to ddmmyyyy , no matter what format i receive.

SLS_MISC_GET_USER_DATE_FORMAT or DATE_CHECK_PLAUSIBILITY & a select statement on the table USR01 cannot be used , as the requirement demands dynamic chnage based on the given date. Experts plz suggest me a go.

Re: Problem with date format

Former Member — Tue, 20 Mar 2007 05:17:33 GMT

hi,

you can achieve it using WRITE TO command no matter whatever format of date taht you get..

for eg. WRITE sy-datum TO GD_DATE DD/MM/YYYY.

declare gd_date(10) as a character var...

if helpful, reward

Sathish. R

Re: Problem with date format

Former Member — Tue, 20 Mar 2007 05:51:06 GMT

Amber,

parameters: p_date(10) type c.

data: date type datum.

CALL FUNCTION 'DATE_STRING_CONVERT'

EXPORTING

DATE_FORMAT = 'YYYY.MM.DD'

DATE_STRING = p_date

START_DATE = SY-DATUM

IMPORTING

RESULT_DATE = date.

Pls. rward if useful

Re: Problem with date format

Former Member — Tue, 20 Mar 2007 06:15:40 GMT

good

if you want to convert the date data dynamically before it upload into the table than you have to store the flat file data into a variable than convert it into the respective format using the if loop ,split statement and concatenate statement.

after converting the data into the respective format you save that into a varibale and upload it into the database table.

thanks

mrutyun^

Re: Problem with date format

Former Member — Tue, 20 Mar 2007 06:22:49 GMT

Hi Kumar,

while uploading the data declare one variable for date and while looping move date into that variable. after that use write to command like following.

data : v_date(8) type c.

data: v_date1(10) type c.

while Prepare the BDCDATA internal table, before uplaod the screen which have the date value declare these validations.

move itab-date to v_date.

WRITE v_date TO v_date1 DD/MM/YYYY.

Now pass v_date1 value to the BDCDATA internal table.

Hope this helps you. Reply for queries.

Regards,

Kumar.