Jeff,

I was just kidding of course: there are no obligations what so ever related to this kind of forums.

I agree: I have got some great solutions which are, that...

Thanks a lot Steve: I understand you solution a little bit better than the others, but the subject stays difficult for me. When I look into the messages as a...

Examining the several solutions offered by Luis Cazares, mister.magoo and SSC Veteran they have one thing in common: I don't fully understand them. Because that's my problem we should not...

Sorry, but I now see what you mean by wrong data. The 2008 dates are mistakenly set in 2012. I try to repair that.

Robert

To all repliers,

Due to the time difference I just saw your proposals: I must say they look great! I am going to examine them and I hope to give a...

Agree

Anthony,

IIF is a new SQL-function in SQL Server 2012 and should work. Your suggestion though works like a charm in all panes so I think I'll use that one.

Thanks a...

Adi,

Thanks: everything is working well now. I apologize for the mixing up the threads.

Grz,

Robert

I would like to but it is not necessary, because we have some misunderstanding. I placed the post in the wrong forum (being reporting services) with the effect of replies...

Anthony,

Thanks for your answers. I tried your solution but that doesnot make any difference. The problem are the panes in Studio: when I use the criteria pane the IIF-function gives...

Rank is just a databasefield and I am referring to it as usual. It must be possible (as with other functions) to use this function in the criteria pane referring...

Sorry for the small misunderstanding but I am using john.arnotts code. The results I mentioned before follow from the following code:

USE [SomeDatabase]

GO

/****** Object: UserDefinedFunction [dbo].[Age2] Script...

I am using your code of course.

SQL Server 2012

The following combinations give a negative result (that is fi 10 yr 3 months and -17 days):

(@dob, @today)

19270424, 19920707

19150131, 20000606

19230622, 20031215

19170124, 20020322

I cannot figure out why that is. Any ideas?

Grz,

Robert