Random number between x an y

[lonesomejubilee]

I need to generate a random number between 1 and 28. How do I do this and if it is over 28, how do I make it go back and try again?

thanks

[Orlando]

Hi Vandy

Here is a calculation I use, I have amended it to your requirements.

1 + Round ( Random * ( 28 - 1 ) ; 0 )

This will generate a random number between 1 and 28 each time, you can have this in a calc or as a set field script step.

I hope this does the trick.

Orlando