Recently during a client project I was given data for when an applicant applied for a position and when they were hired. In order to have a placeholder for the time it takes to interview, I had to generate a random date between them that makes sense.
This can all be done with 1 formula tool.
1st: Calculate the difference between the application date and the hire date
Test: DateTimeDiff([hire_date],[application_date],'days')
2nd: Generate a random number up to the previous difference.
Rand Range: RandInt([Test])
3rd: Add that random number to the application date
Interview_Date: DateTimeAdd([application_date],[Rand Range],'day')
![](https://www.thedataschool.co.uk/content/images/2023/07/image-232.png)