1

Topic: Request on dates and difference comparing

Good afternoon, respected ! Help please with request. There is a table of such type (values huge set). It is necessary to subtract from column IssueDate Birthday and received difference to compare to value - 45 years of 30 days. I.e. this difference of more than 45 years and 30 days will deduce all at whom. (IssueDate - Birthday> 45 years of years of 30 days).

2

Re: Request on dates and difference comparing

twenty7even, add to date of birth of 45 years and 30 days (two dateadd) and compare result to the second date.

3

Re: Request on dates and difference comparing

iii2;
And how to present 45 years and 30 days? I can not think

4

Re: Request on dates and difference comparing

twenty7even wrote:

iii2;
And how to present 45 years and 30 days? I can not think

Numbers, 45 and 30 accordingly

where IssueDate> dateadd (d, 30, dateadd (y, 45, Birthday))

5

Re: Request on dates and difference comparing

alexeyvg, thanks, I will try

6

Re: Request on dates and difference comparing

twenty7even;
It is a little ,
Here you laid out personal data of absolutely another's people in open access, was really lazy to spend for request in addition some seconds and instead of real given to deduce 1, 2, 3...