Conditions
- Random Date: random date between 15 October 1582 and Today
- Firstly, find the timestamp() of your start and end dates.
- You can do this by creating a temporary date property with desired date.
- Then create a formula property with this code: timestamp(prop("Name of Date Property")).
- Copy and paste to page to save for later.
formatDate(dateAdd(fromTimestamp(-12219274800000), round(toNumber(replaceAll(id(), "[^0-9]", "")) % (dateBetween(now(), fromTimestamp(-12219274800000), "days") + 1) * 10 / 10), "days"), "LL")
- Random Year: random year between 1500 and This Year
add(1500, round(toNumber(replaceAll(id(), "[^0-9]", "")) % (year(now()) - 1500 + 1) * 10 / 10))
- Random Day: random day between Monday and Sunday
if(round(toNumber(replaceAll(id(), "[^0-9]", "")) % 7 * 10 / 10) == 0, "Sunday", if(round(toNumber(replaceAll(id(), "[^0-9]", "")) % 7 * 10 / 10) == 1, "Monday", if(round(toNumber(replaceAll(id(), "[^0-9]", "")) % 7 * 10 / 10) == 2, "Tuesday", if(round(toNumber(replaceAll(id(), "[^0-9]", "")) % 7 * 10 / 10) == 3, "Wednesday", if(round(toNumber(replaceAll(id(), "[^0-9]", "")) % 7 * 10 / 10) == 4, "Thursday", if(round(toNumber(replaceAll(id(), "[^0-9]", "")) % 7 * 10 / 10) == 5, "Friday", if(round(toNumber(replaceAll(id(), "[^0-9]", "")) % 7 * 10 / 10) == 6, "Saturday", "")))))))
Random
Name
Random Year
Random Date
Random Day