topic Re: Date format in Parameters in Application Development and Automation Discussions

Date format in Parameters

Former Member — Tue, 27 Jun 2006 07:23:51 GMT

Hi,

I have a Parameter of type date

ppdat LIKE sy-datum

which gets passed to a function, but when I pass it to the function, like this:

ftpost-fvalu = ppdat.

but when it does this the format gets mixed up, how can ensure it is in the format I want?

Thanks

Re: Date format in Parameters

Former Member — Tue, 27 Jun 2006 07:27:50 GMT

Hi sims,

1. Internally the dates are always stored and passed

in YYYYMMDD format only.

2. If your field ftpost-fvalu

is also of type DATE,

then no need to worry.

regards,

amit m.

Re: Date format in Parameters

Former Member — Tue, 27 Jun 2006 07:28:46 GMT

check the fm which format (type char or date) it takes date .

change date parameter to that perticular format

Re: Date format in Parameters

Former Member — Tue, 27 Jun 2006 07:33:08 GMT

Hi,

how have you declared the parameter in the function.

Make sure that the declaration is same in both the places.

Declare the parameter in the function of type like sy-datum.

Hope that helps.

Regards,

Tanveer.

Please mark helpful answers

Re: Date format in Parameters

Former Member — Tue, 27 Jun 2006 07:33:20 GMT

Hi Sims,

Please ensure that the ftpost-fvalu is also of type sy-datum. If thats the case then there is no problem, else if it is of type char then the format will be changed and for using that particular value there will be some complications.

Regards,

Tushar

Re: Date format in Parameters

Former Member — Tue, 27 Jun 2006 07:33:26 GMT

Hello Sims,

I assume that the interface parameter for your function module is of a character data type.

Also, it seems to me that you want the format (the separators) to be preserved when you pass the parameter to the function module.

you can do the following -

parameters ppdat like sy-datum.

data : lv_char_date(10).

start-of-selection.

  write ppdat to lv_char_date.
  
  call function '.....'
    exporting 
      ftpost-fval = lv_char_date.

The WRITE..TO statement ensures that the correct separators are put in place.

Regards,

Anand Mandalika.

Re: Date format in Parameters

vinod_gunaware2 — Tue, 27 Jun 2006 07:33:41 GMT

Convert Useing WRITE INTO

WRITE .... <f> <option>.

Formatting options for all data types

Formatting options for date fields

Option

Function

DD/MM/YY

Separators as defined in user’s master record.

MM/DD/YY

Separators as defined in user’s master record.

DD/MM/YYYY

Separators as defined in user’s master record.

MM/DD/YYYY

Separators as defined in user’s master record.

DDMMYY

No separators.

MMDDYY

No separators.

YYMMDD

No separators.

WRITE: sy-datum,

/ sy-datum yymmdd.

27.06.1995

950627

regards

vinod

Re: Date format in Parameters

Former Member — Tue, 27 Jun 2006 07:40:12 GMT

The parameter is going into a char32 type field, it's a BDC name and value field, and thats what the problem is.

What I need is to store it in the char as

310506 - to represent 31 may 2006

but it stores it in the reverse way.

Re: Date format in Parameters

Former Member — Tue, 27 Jun 2006 07:44:40 GMT

Hi Sims,

Try as follows.

WRITE PPDAT DDMMYY TO ftpost-fvalu.

If your PPDAT as 20060531 then it will be stored in ftpost-fvalu as 310506.

Thanks,

Vinay

Re: Date format in Parameters

Former Member — Tue, 27 Jun 2006 07:47:04 GMT

Hello Sims,

Have you checked my answer above ? Did it not help?

Regards,

Anand Mandalika.