>>Hi,
>>
>>Here is an example and the results with question inline:
>>
>>

>>SET DECIMALS TO 6
>>ldBaseDate = {^1900-01-01}
>>ldCurrDate = DATE()
>>RAND(ldCurrDate - ldBaseDate)

>I see you've solved your original problem. I'm just wondering why you're seeing RAND() this way. Is there some reason RAND(-1) won't work for you?
>
Hi Tamar,

Based on Dmitry's previous post Thread #1387096, he doesn't want random number but rather something that looks like random number but based on a date.