HP3000-L Archives

November 2004, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
OT: Crystal Report formula
From:
KENT WALLACE <[log in to unmask]>
Reply To:
KENT WALLACE <[log in to unmask]>
Date:
Tue, 23 Nov 2004 16:58:19 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (27 lines) 
Anyone

Crystal Reports, VB.net version 9

dim NewMonth as number
dim newyear as number 
let newyear = {@YearSelNum} 
let Newmonth = {@MonthNum} + 1
if newmonth > 12 then
newmonth = 1
newyear = {@YearSelNum} + 1
end if 

formula = cstr(newyear)+ "/" + cstr(newmonth)

It returns 

2003.00/2.00

These are numbers not currency?  What am I doing wrong?

Kent Wallace
Boise, ID

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2