Hi There,
I try to generate a random date between now and the upcoming 3 weeks with randbetween expression, which does not work: Parameter 1 of function RANDBETWEEN is of the wrong type
RANDBETWEEN(TODAY(), TODAY()+21)
I appreciate any help.
Kind regards,
Robert
Solved! Go to Solution.
Please try
TODAY()+RANDBETWEEN(0,21)
RANDBETWEEN() works only with integers. So the above expression will add any random digit between 0 and 21 to todayโs date and will give the same result you desire.
Please try
TODAY()+RANDBETWEEN(0,21)
RANDBETWEEN() works only with integers. So the above expression will add any random digit between 0 and 21 to todayโs date and will give the same result you desire.
User | Count |
---|---|
18 | |
15 | |
10 | |
7 | |
4 |