InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 10:12:42 GMT20http://www.sqlservercentral.com/Forums/Topic1422029-1292-1.aspx[quote][b]ChrisM@Work (2/20/2013)[/b][hr][quote][b]wafw1971 (2/20/2013)[/b][hr]Its alright I have figured it out:...[/quote][url=http://www.sqlservercentral.com/Forums/FindPost1422013.aspx]DwainC already figured it out for you:[/url][code="sql"]SELECT ArrivalDate, BookingDate = DATEADD(day, -(1 + ABS(checksum(NEWID())) % 90), ArrivalDate) FROM BookingsORDER BY ArrivalDate[/code][/quote]I thought this looks familiar. But in the other thread his boss has taken it to the next level. :-PWed, 20 Feb 2013 17:59:06 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1422029-1292-1.aspx[quote][b]wafw1971 (2/20/2013)[/b][hr]Its alright I have figured it out:...[/quote][url=http://www.sqlservercentral.com/Forums/FindPost1422013.aspx]DwainC already figured it out for you:[/url][code="sql"]SELECT ArrivalDate, BookingDate = DATEADD(day, -(1 + ABS(checksum(NEWID())) % 90), ArrivalDate) FROM BookingsORDER BY ArrivalDate[/code]Wed, 20 Feb 2013 05:46:13 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1422029-1292-1.aspxIts alright I have figured it out:SELECT ArrivalDate, DATEADD(day, -1 + RAND(checksum(NEWID()))*-90, ArrivalDate) AS BookingDate FROM BookingsORDER BY ArrivalDateWed, 20 Feb 2013 05:30:53 GMTwafw1971http://www.sqlservercentral.com/Forums/Topic1422029-1292-1.aspxI have an arrival date already in the system and I need to populate the Booking date using a random function, the booking date can be any day on or before the arrival date up to a maximum 90 days previous but it must be random the booking date cannot all be the same date.I thought I cracked it but was wrong. Can you help? SELECT ArrivalDate, DATEADD(day, -1 + RAND(checksum(NEWID()))-90 , ArrivalDate) AS BookingDate FROM Bookings ORDER BY ArrivalDateThanks WayneWed, 20 Feb 2013 05:18:23 GMTwafw1971