date manipulation

[Former Member]

i have in a string 1/11/2007

i am doing this manipulation

V_year = <fs_upfile>-value+5.

v_month = <fs_upfile>-value+2(2).

v_day = <fs_upfile>-value(1)

and putting it in a field bwdat

but i don't know in advance if string will contain 11/11/2007 or 1/11/2007

[Former Member]

Try

SPLIT <fs_upfile>-value AT '/' INTO v_day v_month_v_year.

Regards,

Nick

[Former Member]

try like this..

V_year = <fs_upfile>-value+5(4).
v_month = <fs_upfile>-value+2(2).
v_day = <fs_upfile>-value+0(1).
CONCATENATE v_year v_month v_day INTO bwdat.
"I'm not sure because date always can't be 1/11/2007
"some tiems may be 21/11/2007
"this case you've to use 
"v_day = <fs_upfile>-value+0(2).

Message was edited by:

Perez C

[Former Member]

Hi,

You can use split option and put all the resultant values into 3 variables containg day month year.

SPLIT <field> AT '/' INTO v_day v_month_v_year.

Otherwise if you want to follow your way only means you can do by calculating string length by strlen(field)

if it is 9 means you use ur way.

If the length is 10 means you change

V_year = <fs_upfile>-value+6(4).

v_month = <fs_upfile>-value+3(2).

v_day = <fs_upfile>-value+0(2)

Please reward points if its useful.

Thanks

Sivaparvathi