Random dates inside a month

Hi! Im having trouble wrapping my head aroubd this but I am trying to duplicate records and assign then a random date inside the current month and then make them not to duplicate on the same date.

So duplicate 1 = month/day 5
Duplicate 2 = month/day 7

And so on on a random fashion but checks not to create one on the same date as another duplicate. I will have them linked by month.

Any help appreciated

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.