cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Number of places for reporting

SOLVED

Re: Number of places for reporting

OK.  Thank you for your help.

Re: Number of places for reporting

I figured out how to set it to show the actual values.

 

On the Select tab add the function "To Number".

Select somewhere else on the tree to get it to display correctly.

Then select the To Number and then Add button again.  It will give a sub-entry:

ToNumber.JPG

 

This now shows whatever the value in the attribute actually is.

View solution in original post

Re: Number of places for reporting

It is something convoluted in the same way to get the very latest revision.

Marco

Re: Number of places for reporting

But it is much easier.

 

I don't think I would have found it without your suggestion of the DATEDIFF function.  I started thinking there has to be some other function that does this so I tested several others and came across the To Number.

 

So thank you Marco!

Re: Number of places for reporting

So now that we migrated to version 11.0 M030 the "To Number" is not longer needed.  I originally needed it in 10.1 to make it show as a real number.  I have removed that.

 

WOW!

Re: Number of places for reporting

We have just moved to 11.1 earlier this year and I was looking to use the DATEDIFF function just today, but found that is is not present.  It does still show up in the WC Help for 11.1 though.  Does anyone know if this has been deprecated?  Subtract might work... but not the same as DATEDIFF where you can specify the time component which to compare (e.g. days, hours, weeks, etc).  That is a handy function.

Announcements
LiveWorx Call For Papers Happening Now!