topic Re: date manipulation in Application Development and Automation Discussions

date manipulation

Former Member — Wed, 12 Dec 2007 14:17:43 GMT

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

Re: date manipulation

Former Member — Wed, 12 Dec 2007 14:20:37 GMT

Try

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

Regards,

Nick

Re: date manipulation

Former Member — Wed, 12 Dec 2007 14:21:43 GMT

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

Re: date manipulation

Former Member — Wed, 12 Dec 2007 14:32:06 GMT

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