topic Re: DATE FORMAT in Application Development and Automation Discussions

DATE FORMAT

Former Member — Fri, 26 May 2006 09:24:12 GMT

Hi,

i have a date 20060720 stored in a variable of type sy-datum. How do i convert it to format 20.07.2006 while printing it through a sapscript

regards

Nishant

Re: DATE FORMAT

Former Member — Fri, 26 May 2006 09:25:40 GMT

Hi nishant,

1. no need to convert.

2. In the layout just mention

&mydate&

3. it will automatically print

in dd.mm.yyyy format

(based upon user settings)

regards,

amit m.

Re: DATE FORMAT

Former Member — Fri, 26 May 2006 09:26:26 GMT

hi,

data : date(10),
       dat type sy-datum.

date = '20060720'.

dat = date.

Regards

vijay

Re: DATE FORMAT

Former Member — Fri, 26 May 2006 09:27:12 GMT

REPORT ZES .

data: v_date type char10.

CALL FUNCTION 'HRGPBS_HESA_DATE_FORMAT'

EXPORTING

p_date = sy-datum

IMPORTING

DATESTRING = v_date.

replace all occurences of '/' in v_date with '.' .

write v_date.

hope it solves your problem. pls close the thread by allocating points if u satisfy with solutions.

Re: DATE FORMAT

guillaume-hrc — Fri, 26 May 2006 09:27:18 GMT

Hi,

Why not use another variable of type character that you would fill with a WRITE statement from the first variable ?

Another possibility would be to use offset - such as mydate+0(2) - on the date variable directly into the SAPscript.

Hope it helps.

Best regards,

Guillaume

Re: DATE FORMAT

Former Member — Fri, 26 May 2006 09:27:53 GMT

hi Nishanth,

Amit is Right it print in the way you want.

Regards,

Santosh

Re: DATE FORMAT

Former Member — Fri, 26 May 2006 09:27:57 GMT

use &date&

it will write

Re: DATE FORMAT

andreas_mann3 — Fri, 26 May 2006 09:28:24 GMT

Hi,

try fm CONVERT_DATE_TO_EXTERNAL

Andreas

Re: DATE FORMAT

nishanthbhandar — Fri, 26 May 2006 09:29:16 GMT

In any SAP screen check SYSTEM->USER PROFILE->OWN DATA.This will show the user's default parameters.Check the defaults tab.Under the Date Format check the radiobutton DD.MM.YYYY.Dont do anything if it is already checked.This is the format that is taken to print the SY-DATUM value.

Cheers

Nishanth

Message was edited by: Nishanth Bhandar

Re: DATE FORMAT

Former Member — Fri, 26 May 2006 09:29:37 GMT

Hi Amit,

...".. In the layout just mention

&mydate&"

Can you please be more specific....

regards

Re: DATE FORMAT

former_member480923 — Fri, 26 May 2006 09:29:59 GMT

Use the following codes

Report z.......

data v_date(10) type c.

write date to v_date.

........

in SAPScript pass v_date and write as v_date..

this will work if ur dateformat is DD.MM.YYYY

Hope it helps

Anirban

Re: DATE FORMAT

Former Member — Fri, 26 May 2006 09:33:21 GMT

Check this link too.

http://help.sap.com/saphelp_erp2004/helpdata/en/d1/803411454211d189710000e8322d00/frameset.htm

Thanks,

Susmitha

Re: DATE FORMAT

nishanthbhandar — Fri, 26 May 2006 09:33:34 GMT

mydate is just the sample variable name that Amit has mentioned.he just means that u r supposed to put ur variable for date in that place.The default format as i mentioned earlier will be picked up frpm the User's master data.That's all.

Re: DATE FORMAT

Former Member — Fri, 26 May 2006 09:34:05 GMT

Hi again,

1. In your layout using se71,

u must be writing some other texts,

along with the position, at which,

u want your date to be printed.

2. So, suppose your variable name for date

(in driver program)

is MYDATE,

then

3. just use / type

in layout as,

&MYDATE&

4. Eg.

Todays Date is &MYDATE&

regards,

amit m.

Re: DATE FORMAT

Former Member — Fri, 26 May 2006 09:39:46 GMT

Hii

use

e.g. /: SET DATE MASK = ‘MM DDDD (Day in full) yyyy’

otherwise

&sydatum&