Assigning random dates in alteryx

[Bharath]

Hi ,

I have 10000 records which I have to assign randomly between the dates jan 01, 2016 to may 26 , 2016. Please le tme know about it.

Thanks,

Bharath

[michael_treadwell · Accepted solution]

There are 147 days (inclusive) between Jan 1, 2016 and May 26, 2016. Using the Formula tool you can create a column called [Random Date]:

DATETIMEADD('2016-01-01', RANDINT(146), 'days')

This will add a random number of days between 0 and 146 to Jan 1, 2016

[Bharath]

Hi Michael,

yes it works. Thank you for helping me on this.

- Bharath