subtracting variables - a rookie question

[lvadmin]

eventtimenew = eventtime - newtime
@1,1 say eventtimenew


I get 100020(should really be 9980.)
1000 - 20

eventtimenew = "eventtime" - "newtime"

I get eventtimenewtime


What am I doing wrong here?

 

[Mike Lewis]

Lvadmin,

It looks like you are substracting two strings. When you do that. VFP joins the strings together, while removing any intermediate spaces.

Try this:

eventtimenew = val(eventtime) - val(newtime)
@1,1 say eventtimenew

That will convert the strings to numbers. Subtraction will then work as you expect it to.

Mike



Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[lvadmin]

Nice

The calculation works nice but I want to sent that to another variable and get rid of the decimal in 9980.00

I am having a problem saying:

store substr(eventtimenew,1,4) to test
say test

I get an error????

help

 

[mspratt]

store str(eventtimenew,1,4) to test
say test

Regards,

Mike

 

[Mike Lewis]

Lvadmin,

I am having a problem saying:
store substr(eventtimenew,1,4) to test

That's because EventTimeNew is a numeric variable, and substr() only works on strings. Use the STR() function to convert numeric to string. The third argument of that function specifies how many decimal places you want.

Mike



Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com