topic Re: date format in Application Development and Automation Discussions

date format

Former Member — Tue, 08 Jan 2008 07:18:05 GMT

hi all,

i have an issue of the date format at the selection screen,

i have actually PARAMETERS: p_date TYPE sy-datum DEFAULT sy-datum. the default is sy-datum but the requirement is to display date in Format - MM/DD/YYYY. by date mask we can maximum get Format - DD/MM/YYYY BUT this not exactly they wanted.please help on this issue. i need to get this date format at selection screen default value.

Re: date format

Former Member — Tue, 08 Jan 2008 07:23:14 GMT

Use CONCATENATE and SPLIT command and convert sy-datum to your desired format.

Do this in INITIALIZATION event and pass it to parameter p_date.

Re: date format

Former Member — Tue, 08 Jan 2008 07:26:30 GMT

Verma,

under below event

INITIALIZATION.

DATA : v_date like sy-datum.

concatenate sy-datum4(2) '/' sy-datum6(2) '/'

sy-datum+0(4) into v_date.

p_date = v_date.

if length is not sufficient make P_date and v_date of length

Don't forget to reward if useful.

Re: date format

Former Member — Tue, 08 Jan 2008 07:29:10 GMT

Hi,

thats all dependent on user profile settings.For me iam getting what you wanted .because by default that option is active.You can also do the samething by going to the menupath

In the selection screen you have menu path

SYSTEM~~->USERPROFILE~~>OWNDATA-->DEFAULTS tab -->HERE YOU GIVE CHOICE WHAT EVER FORMAT YOU WANTED.

aND REEXECUTE THE PROGRAM ONCE YOU CHOOSE.

oTHERWISE SOMETIMES YOU HAVE TO RESTART SAP.

it will definitely work for your issue. If any issue please revert back.

Regds

Sivaparvathi

Please reward points if helpful..

Re: date format

Former Member — Tue, 08 Jan 2008 08:37:10 GMT

Hi Abhinash,

Kindly check if the below logic will help you out.

(This is sample code written to get the date in required format)

TYPES: BEGIN OF ty_date,

yyyy TYPE char4,

mm TYPE char2,

dd TYPE char2,

END OF ty_date.

DATA: l_date TYPE sydatum,

ls_date TYPE ty_date,

l_req_date_format TYPE char10.

l_date = sy-datum.

ls_date = l_date.

CONCATENATE ls_date-mm '/' ls_date-dd '/' ls_date-yyyy INTO l_req_date_format.

WRITE / l_req_date_format.

Regards,

Farheen

Re: date format

Former Member — Tue, 08 Jan 2008 09:00:57 GMT

Hai,

use command SET COUNTRY 'US' in START-OF-SELECTION..

This may help you.

Sample Code:

REPORT zaer_test1 .

DATA: RECEIVER_COUNTRY LIKE T005X-LAND VALUE 'US'.

PARAMETERS: DT TYPE SY-DATUM.

INITIALIZATION.

START-OF-SELECTION.

SET COUNTRY RECEIVER_COUNTRY.

END-OF-SELECTION.

write: /10 DT.

Re: date format

Former Member — Tue, 08 Jan 2008 09:23:33 GMT

Hi, this may help you.

This coding will help you to display the date in the format 'mm/dd/yyyy'.

DECLARE @DT DATETIME

SET @DT = '2003-01-22 10:31 PM'

SELECT '0' + CAST(MONTH(@DT) AS CHAR(1)) + '/' + CAST(DAY(@DT) AS

CHAR(2)) + '/' + CAST(YEAR(@DT) AS CHAR(4))

With Regards

Madhu

Re: date format

Former Member — Wed, 23 Jan 2008 06:38:13 GMT