topic Date Format in Application Development and Automation Discussions

Date Format

Former Member — Tue, 27 May 2008 11:05:37 GMT

Hi,

Is there any function module to convert date from 5-12-2008 to 2008-12-05?

Please help ..

Re: Date Format

Former Member — Tue, 27 May 2008 11:06:25 GMT

Hi,

Use these function modules for any date format conversions.

CONVERSION_EXIT_PDATE_INPUT,

CONVERT_DATE_TO_INTERN_FORMAT,

CONVERT_DATE_FORMAT,

CONVERT_DATE_TO_EXTERNAL,

CONVERT_DATE_TO_INTERNAL,

CONVERT_DATE_INPUT.

Regards,

Jagadish

Re: Date Format

Former Member — Tue, 27 May 2008 11:08:06 GMT

is the form 2008-12-05 your internal system date?

then you can use SYSTTIMLO to convert it in internal format.

Also if you can check

RKE_TIMESTAMP_CONVERT_OUTPUT

Hope it helps

Re: Date Format

Former Member — Tue, 27 May 2008 11:08:18 GMT

Hi,

Use the Function module CONVERSION_EXIT_PDATE_INPUT which Resolves your

Requirement.

Reward if useful.

Regards

Raj.

Re: Date Format

Former Member — Tue, 27 May 2008 11:09:03 GMT

date_old = 2008-05-27

day = date_old+8(2)

month = date_old+5(2)

year = date_old(4)

concatenate day '-' month '-' year into date_new.

Re: Date Format

Former Member — Tue, 27 May 2008 11:12:45 GMT

Hello,

you can use edit mask 'yyyymmdd'.

(or)

Check the below code :

data v_mdate(8) type c.

data : v_date(8) type c,

v_day(2) type c,

v_mon(2) type c,

v_year(4) type c.

start-of-selection.

v_mdate = '01012007'." to 20070101

v_year = v_mdate+4(4).

v_mon = v_mdate+2(2).

v_day = v_mdate+0(2).

concatenate v_year v_mon v_day into v_date.

write:/ v_date.

***************Reward points,if found useful

Re: Date Format

Former Member — Tue, 27 May 2008 11:14:42 GMT

Hi Poonam,

Check this out

CONVERSION_EXIT_PDATE_INPUT

- Conversion Exit for Domain GBDAT: DD/MM/YYYY -> YYYYMMDD

Re: Date Format

Former Member — Tue, 27 May 2008 11:15:58 GMT

hey which function module to use for yyyymmdd???

Re: Date Format

Former Member — Tue, 27 May 2008 11:18:11 GMT

i dnt understand why you need to use a FM.

U can alwys use SYSTDATLO system variable to change the

date in internal format.

Hope it helps

Re: Date Format

Former Member — Tue, 27 May 2008 11:18:30 GMT

its for mm/dd/yyyy.

Re: Date Format

Former Member — Tue, 27 May 2008 11:23:27 GMT

date_old(10) type c value '27-05-2008'.

date new(10) type c.

day = date_old+2(2)

month = date_old+3(2)

year = date_old+6(4)

concatenate year '-' month '-' day into date_new.

Re: Date Format

Former Member — Tue, 27 May 2008 11:27:17 GMT

thanks fr the helpful answer.

please tell me how to prefix 0 to 5-12-2008?

using concatenate??

please help...

Re: Date Format

Former Member — Tue, 27 May 2008 11:31:24 GMT

Hi,

Define output type as sy-datum.

Thanks,

Sriram Ponna.