topic Re: substring functions. in Application Development and Automation Discussions

substring functions.

Former Member — Mon, 14 Apr 2008 08:31:22 GMT

i have a date variable which has 21.03.2008 ie DD.MM.YYYY format.

i want to extract month and year separately into different variables.

wht is eh function or way to do it.

Former Member — Mon, 14 Apr 2008 08:34:26 GMT

hi,

do this way ..


data : v_date(1) value '21.03.2008',
         v_month(2),
         v_year(2).

 v_month = v_date+3(2).
 v_year   =  v_date+6(4).

Regards,

Santosh

Former Member — Mon, 14 Apr 2008 08:34:42 GMT

try this function


USS_DATE_DECOMPOSITION

bye

peter_ruiz2 — Mon, 14 Apr 2008 08:35:02 GMT

hi,

if your date is exactly the same with how you write it including the periods.

use this code

month = datum+3(2)

date = datum (2)

Former Member — Mon, 14 Apr 2008 08:46:24 GMT

Check this simple program

DATA : date type string,

dd type char2,

mon type char2,

year type char4.

date = '21.04.2008'.

SPLIT date at '.' into dd mon year.

WRITE :

dd, mon, year.

HOPE IT HELPS.

Former Member — Mon, 14 Apr 2008 09:03:41 GMT

Hi,

Use the below function module.

CACS_DATE_GET_YEAR_MONTH