topic Re: Date format in Application Development and Automation Discussions

Date format

Former Member — Tue, 22 Nov 2005 12:55:28 GMT

Hi Guys,

I have to find out format of a date field which is stored in a field symobl.

assume <f1> = 11/11/2005.

I need to whether it is in MM/dd/yyyy or dd/mm/yy...like that.

After i need to convert this to a YYYYMMDD format...

Do i have any functionModules or logic exist for this.

Earliest response is appreciated.

Thanks in advance.

Raja.

Message was edited by: raja gurrala

Re: Date format

Former Member — Tue, 22 Nov 2005 13:00:14 GMT

Raja,

For your Q 2 (convert this to a YYYYMMDD format..), use the function module 'CONVERSION_EXIT_IDATE_INPUT'.

Make sure u give the input date is in the format ddmmyyyy or dd.mm.yyyy

Thanks

Kam

Re: Date format

athavanraja — Tue, 22 Nov 2005 13:02:00 GMT

if the intention is to converti the external date format to internal format simply use the following FM

DATE_CONV_EXT_TO_INT

Regards

Raja

Re: Date format

Former Member — Tue, 22 Nov 2005 13:04:06 GMT

Hi Raja,

Can you please tell me Which Version of SAP you are Using, because Some FM's are Available in Some Versions of SAP Only.

Please get back to me Immediately, So that I will surely get you the Idea of it.

Thanks,

Satya Krishna .M

Re: Date format

Former Member — Tue, 22 Nov 2005 13:05:09 GMT

I don't know if there is a fm, but you can split the date and analyze the single values:

SPLIT <f1> AT '/' INTO DAY MONTH YEAR.

CONCATENATE YEAR MONTH DAY INTO DATE.

I think it won't be easy to know if the date format is MM/DD/YYYY or DD/MM/YYYY, you can be sure only if you can know how the date is stored in field symbol.

The format of the date usually depends on user attributes, if it's your case, check the table USR01, field DCPFM.

Max

Message was edited by: max bianchi

Re: Date format

Former Member — Tue, 22 Nov 2005 13:08:58 GMT

raja,

would this works for..

if my datefield format is ..

11/11/2005 or 11-11-2005...etc..

to give in export structure u mentioned..

Re: Date format

Former Member — Tue, 22 Nov 2005 13:10:52 GMT

satya,

i am using 4.6c.

can i have some FMs here..

Re: Date format

athavanraja — Tue, 22 Nov 2005 13:13:29 GMT

we are on ECC5 (WAS6.4)

Regards

Raja

Re: Date format

Former Member — Tue, 22 Nov 2005 13:13:32 GMT

Max ..easily i can split...and work out for my logic..

But

the problem in dif countries people use dif formats..

example dd/mm/yyyy or mm/dd/yyyy..or some other..

So if i split that how would i come to know that ..which is earlier two digits are day or months...

i hope u understand my problem..

Re: Date format

Former Member — Tue, 22 Nov 2005 13:17:51 GMT

Hi Raja,

There is one FM to Convert the Date to the Internal Format. Whatever the Date Format, You can Pass that Date to this FM through FS, It Automatically Converts to the Internal Format of the System. Please use this FM.

CONVERT_DATE_TO_INTERN_FORMAT

Please Pass the Parameters of the DATA Format and the DTYPE as DATS.

Thanks,

Satya Krishna.M

Re: Date format

athavanraja — Tue, 22 Nov 2005 13:18:33 GMT

i am not sure whether function i mentioned in available in 4.6C

you can also use

CONVERT_DATE_INPUT

CONVERT_DATE_TO_INTERNAL

but these will allow you to pass only user specific date format as input

Regards

Raja

Re: Date format

Former Member — Tue, 22 Nov 2005 13:19:00 GMT

I know it, dO you try to see the date format stored in USR01?

Max

Re: Date format

Former Member — Tue, 22 Nov 2005 13:19:30 GMT

Hi Raja,

Please let you know more FM's, let me do R & D on this.

Please be Patient, Will let you know the Answer for this.;

Thanks,

Satya Krishna.M

Re: Date format

Former Member — Tue, 22 Nov 2005 13:19:40 GMT

Raja,

Even if u split the date, u will have problem in recognization.

If suppose the Date is '11/12/2005' or '12/11/2005' or '09/12/2005'(for eq), then u would not be in a position to find the correct Day and Month!!!!!

Thanks

Kam

Re: Date format

Former Member — Tue, 22 Nov 2005 13:24:09 GMT

Hi Raja

In the table T005X (field DATFM) you can find out the date format for country;

In the table USR01 (field DATFM) you can find out the date format for user.

Max

Re: Date format

Former Member — Tue, 22 Nov 2005 13:24:20 GMT

Raja,

here is another FM, Which you can get the Format of the Date.

SLS_MISC_GET_USER_DATE_FORMAT

Thanks,

Satya Krishna Madasu

Re: Date format

Former Member — Tue, 22 Nov 2005 13:39:59 GMT

Hi satya,Draja,Max,kam...

Thank u very much for instant replies.

i am a junior level programmer.

I copied the <FS> to a l-dtmp char(10) field.

CALL FUNCTION 'DATE_CONV_EXT_TO_INT'

EXPORTING

I_DATE_EXT = l_dtmp

IMPORTING

E_DATE_INT = l_date.

I used this FM ..and i got the field into l_date also as 11/11/2005...

If i assign this to

standard date field...

it copied as ...20051111.( this is what i required)..

Is this solution ok?

works for all instances..

like..if the format is 11-11-2005..??

As i am a beginner ..i need clarification to include this solution to mine..

Message was edited by: raja gurrala

Re: Date format

Former Member — Tue, 22 Nov 2005 13:45:25 GMT

Hi Raja,

By using the function module 'SLS_MISC_GET_USER_DATE_FORMAT', you can get the format of the date in your system. Based on this you split that into year,month and date. Later you can write into whatever format you want.

Regards,

Rajavardhana Reddy

Re: Date format

Former Member — Tue, 22 Nov 2005 13:47:24 GMT

Guys ,

Needed clarification for my previous posting!!!..

Experts..plz do make comments ..on my proposed solution and clarify my misgivings..

Re: Date format

Former Member — Tue, 22 Nov 2005 14:21:40 GMT

Hey Raja,

I have Cross Checked with the Date Format you have like 11-11-2005, you cannot give this type of format to the FM, Whether you should give without any wild characters into it.

you can give like 11112005 and its converts into the Standard Internal Format,

Please tell me raja, Whether the FM's Which is given by me, is useful to you for this Case.

Thanks,

Satya Krishna.M