Surely
OneYear = 101
Current = 0203
*
NextYr = ( Current + OneYear ) "R(0)#4"
would be simpler???
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
On Behalf Of djordan
Sent: 31 March 2004 12:36
To: 'U2 Users Discussion List'
Subject: RE: Data typing in MV Basic
The issue I have had to deal with, which may be common to
this
discussion is where we use fiscal year 0203 for 2002/2003.
If you do A = 0203, then sometimes but not always it becomes
203. where
a = "0203" it remains 0203.
If you want to add a year to make 0203 to 0304 requires
something like
this
A = 0203
B = ((10000+A)[2,2])+101)[2,2]):(10000+A)[2,2])
(This also takes Y2K into account that is why it looks more
complex than
it should)
Regards
David Jordan
Senior Consultant
[EMAIL PROTECTED]
Dacono Holdings Pty Ltd
Business & Technology Consulting
PO Box 909
Lane Cove
NSW 2066
Australia
Ph 61 2 9418 8329
Fax 61 2 9427 2371
www.dacono.com.au
----
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
