I reckon it's somewhere around your DOB, Lowell 😛
SELECT *
FROM (SELECT ticks = 624511296000000000) z
CROSS APPLY (SELECT microseconds = z.ticks/100) a
CROSS APPLY (SELECT milliseconds = a.microseconds/1000) b
CROSS APPLY (SELECT [seconds] = b.milliseconds/1000) c
CROSS APPLY (SELECT [minutes] = c.[seconds] / 60) d
CROSS APPLY (SELECT [hours] = d.[minutes] / 60) e
CROSS APPLY (SELECT [days] = e.[hours] / 24) f
CROSS APPLY (SELECT startdate = DATEADD(DD,0-f.[days],GETDATE())) g
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]