Generate random dates between two dates

[BOTFORCE]

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

[Suvrutt_Gurjar · Accepted 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.

help.appsheet.com

RANDBETWEEN()

Random integer from range