Random date in YYYYMMDD

The supported date formats do not include the old school YYYYMMDD format.

Turns out you can do this in ruby in the formula editor:

(now() - days(random(0,5000))).strftime(’%Y%m%d’)

This will give you ~15 years of random dates.