Restricting dates

#1

Hi,

I have a field called begin_date which I have restricted to between 4/12/2000 and 4/12/2016. I want to create an end_date field which must be greater than the begin_date but less than the current date. I would like the end_dates. Is there a way to generate this field using a formula?

I know how to generate a random number of days after the begin_date but not how to limit it so that it is not greater than today’s date.

Thanks!

#2

Try this formula:

begin_date + days(random(0, date_diff('days', begin_date, now())))

3 Likes
#3

Great! This worked. Thank you!