topic Re: Date format in Application Development and Automation Discussions

Date format

Former Member — Thu, 05 Mar 2009 09:48:50 GMT

Hi,

I have two problems 1:to change the length of the date from 8 to 6 but unfortunately it is giving me an error. 2: there is fields that I need to display lfart from likp it has a value of zslr or zslf but the client want to see d for zslf only not a zslr. this means this field must only display d and d id the default.

Regards,

Fred

Re: Date format

Former Member — Thu, 05 Mar 2009 09:52:56 GMT

Your question was confusing and not clear. Can you look into your question and post it back with example in date format. Explain clearly.

Re: Date format

GauthamV — Thu, 05 Mar 2009 09:55:54 GMT

1. your requirement is not clear



If itab-lfart = 'ZSLF'.

itab-lfart = 'd'.

else.
-----------
-----------
endif.

Re: Date format

sarbajitm — Thu, 05 Mar 2009 10:01:15 GMT

1.you cannot change the length of date field because the default internal length for date field is 8 which is fixed. And date get stored internally in YYYYMMDD format.

Re: Date format

Former Member — Thu, 05 Mar 2009 10:13:42 GMT

Hi,

Use EDIT MASK

Regards

Md.MahaboobKhan

Re: Date format

Former Member — Thu, 05 Mar 2009 10:42:32 GMT

Hi,

This is my question how do you change the length of the date? Currently the length of the date is 8 YYYYMMDD and I am expected to change it 6 YYMMDD, that is the first part of the question.

The second part is that there is a field by the name of lfart from likp, currently it has the value zslf and zslr but the client only wants to see the default value of which is zslf, but they do not want to see full zslf they only want to see D.

Hope it is now clear.

Best Regards,

Fred.

Re: Date format

ashish_shah5 — Thu, 05 Mar 2009 10:47:46 GMT

Hi,

Suppose I m getting values in var1 = YYYYMMDD .

Use VAR1+2(6)

Regards,

Re: Date format

Former Member — Thu, 05 Mar 2009 11:26:28 GMT

Hi,

I am happy the length of the date is now 6 but the format must be MMDDYY.

Regards,

Fred.

Re: Date format

Former Member — Thu, 05 Mar 2009 11:29:42 GMT

Can you explain your requirement in clear.

It is not possible to change date format from 8 to 6.

Regards,

Rajani

Re: Date format

Former Member — Thu, 05 Mar 2009 11:50:25 GMT

Hi,

I got my anwer, but just to refresh your mind i wanted to display the date in 6 characters and i got the answer. As for now I need to change the format from YYMMDD to MMDDYY, if this can be sorted my question is answered.

Best Regards,

Fred.

Re: Date format

Former Member — Thu, 05 Mar 2009 12:01:12 GMT

Hi Fred,

The internal format for the date is YYMMDD but when you output that field in the output screen then it will change the format of the Date.

Please get into the table from which you are extacting this field and double click on Data element

and then double click on Domain.

Let me know if you have any Convers. Routine available in that field...?

Please let me know if this is not the case...

Regards,

Kittu

Re: Date format

Former Member — Thu, 05 Mar 2009 12:01:36 GMT

Hi Fred,

The internal format for the date is YYMMDD but when you output that field in the output screen then it will change the format of the Date automatically.

Please get into the table from which you are extacting this field and double click on Data element

and then double click on Domain.

Let me know if you have any Convers. Routine available in that field...?

Please let me know if this is not the case...

Regards,

Kittu

Sorry for the same message, it was typo...

Edited by: Kittu on Mar 5, 2009 1:01 PM

Re: Date format

Former Member — Thu, 05 Mar 2009 12:08:39 GMT

Hi,

The Convers. Routine is empty there nothing on it.

Best Regards,

Fred.

Re: Date format

Former Member — Thu, 05 Mar 2009 12:32:35 GMT

Hi Fred,

If you want to change the Date format from YYYYMMDD to MMDDYY,

I am sure this will help you.

*****************************************************************************

data :var1(6) type c,

var2(8) type c,

date1 like sy-datum.

date1 = sy-datum.

concatenate date14(4) date12(2) into var1.

concatenate date14(2) '.' date16(2) '.' date1+2(2) into var2.

write: date1, / , var1, /, var2.

**************************************************************************************

output is,

DD.MM.YYYY

MMDDYY

MM.DD.YY

As per your requirement I have written this.

The internal format of date would be YYYYMMDD (of 8 characters)

The external format of date would be DD.MM.YYYY

Using the above program logic you can convert it to any format you wish.

Thank you.

Veera Karthik.

Edited by: veera Karthik on Mar 5, 2009 1:33 PM

Re: Date format

Former Member — Thu, 05 Mar 2009 12:55:17 GMT

hi,

Take that date in a variable Var (YYMMDD).

Declare three more variables, var1, var2, var3.

var1 = var+0(2).

var2 = var+2(2).

var3 = var+4(2).

Then Concatenate these three variables the way u want.

ie MMDDYY.

Hope this helps.

Thanks

Suraj S Nair

Re: Date format

ashish_shah5 — Thu, 05 Mar 2009 12:57:45 GMT

HI,

Now you are getting DDMMYYYY.

Just Change ur declaration.

Data: Var(6).

So now u will get DDMMYY in VAR variable.

Regards

Re: Date format

Former Member — Fri, 06 Mar 2009 09:11:13 GMT

Hi,

I still have a problem, when I view my downloaded data it displays with 8 characters instead of 6... Can anyone help me with that?

Regards

Fred

Re: Date format

Former Member — Fri, 06 Mar 2009 09:15:15 GMT

Hi,

In your code where ever u download the Date, get it into a variable and then do the necessary things that I mantioned earlier and then desplay it.

Hope this will help u,

Or else pls paste ur code

Thanks and Regards

Suraj S Nair

Re: Date format

Former Member — Fri, 06 Mar 2009 09:19:10 GMT

Use FM: HRGPBS_TPS_DATE_FORMAT

Reagards,

Rajesh.

Re: Date format

Former Member — Fri, 06 Mar 2009 09:20:37 GMT

data :var1(6),

var2(8) c,

date1 like sy-datum.

date1 = sy-datum.

concatenate date14(4) date12(2) into var1.

concatenate date14(2) '.' date16(2) '.' date1+2(2) into var2.

write: date1, / , var1, /, var2.