Skip to Content
0
Former Member
Nov 20, 2012 at 06:04 PM

In need of a unique (random) # for duration of report

25 Views

I'm printing labels and I need a unique number to tie the labels together

I was going to user somthing like

@DatetimeSeed defined as

ToNumber(ToText(Year(CurrentDate),0) + ToText(Month(CurrentDate),0) + ToText(Day(CurrentDate),0) +

ToText(Hour(CurrentTime),0) + ToText(Minute(CurrentTime),0) + ToText(Second(CurrentTime),0))

Random Number defined as

ToNumber(ToText({@DateTimeSeed},0) + ToText((RND({@DateTimeSeed}) * 100),0))

The only problem is that every line has a different value

Any suggestion