declare @t table (creationdate datetime)

insert @t values('20020731')
insert @t values('20020801')
insert @t values('20020802')
insert @t values('20020803')
insert @t values('20020804')
insert @t values('20020805')
insert @t values('20020806')
insert @t values('20020807')
insert @t values('20020808')
insert @t values('20020809')
insert @t values('20020810')
insert @t values('20020811')
insert @t values('20020812')
insert @t values('20020813')

declare @crdate datetime
set @crdate = '20020801'

select datediff(day, a.CreationDate, @CrDate) from @t a