Re: [DataVision-users] complex ruby formulae

[Jim M. <ji...@io...>]

Paul Taylor wrote:
> Obviously my spell-checker doesn't like the word "ruby", so it replaced it
> with "rugby", but for the record, American football is a bastardization of
> rugby, not the other way around - that's just payback.
> 
>  
> 
> With respect to formulae, I'm trying to do something that is more complex
> than the simple if statement in the sample reports. I've looked through the
> rugby docs but to no avail.
> 
>  
> 
> I have a field called CURRDUDATE - it is a date stored as a long. eg
> 20040828 
> 
> The 1st 3 lines give me 3 variables - year, month & day.
> 
> The 4th line is supposed to construct a string.
> 
>  
> 
> y ={job.CURRDUDATE}/10000
> 
> m ={job.CURRDUDATE}/100 - y*100
> 
> d ={job.CURRDUDATE} - y*10000 - m*100
> 
> dt = y.to_s +"-"+ m.to_s +"-"+ d.to_s
> 
>  
> 
> My inexperience with ruby syntax is getting in the way.

That looks good, but perhaps (I'm just guessing) DataVision thinks CURRDUDATE 
is a string. In fact, it might be easier to manipulate it as a string:

curr_du_date = {job.CURRDUDATE}.to_s # Force conversion to string
curr_du_date =~ /(\d\d\d\d)(\d\d)(\d\d)/
return "#$1-#$2-#$3"

Alternately, you could use a UserColumn and have your database perform the 
conversion by using one of its built-in formatting functions.

Jim
-- 
Jim Menard, ji...@io..., http://www.io.com/~jimm