I have a
complicated SQL query that is not being accepted as an SQL driven Default Value
and I can't find out why. When I click the Update and Exit it disappears. Any
ideas would be much appreciated.
SELECT
DATENAME(MONTH,DATEADD(HOUR,14,GETDATE()))
+ '-' +
CAST((CASE WHEN DATEDIFF(YEAR,DATEADD(HOUR,14,CONVERT(DATETIME,
UserProfile.PropertyValue,101)),CONVERT(DATETIME,'04/01/' +
CAST(YEAR(GETDATE()) AS VARCHAR(10)),101)) <= 0
THEN 0
WHEN DATEDIFF(YEAR,DATEADD(HOUR,14,CONVERT(DATETIME,
UserProfile.PropertyValue,101)),CONVERT(DATETIME,'04/01/' + CAST(YEAR(GETDATE())
AS VARCHAR(10)),101)) >= 18
THEN 18
ELSE DATEDIFF(YEAR,DATEADD(HOUR,14,CONVERT(DATETIME,
UserProfile.PropertyValue,101)),CONVERT(DATETIME,'04/01/' +
CAST(YEAR(GETDATE()) AS VARCHAR(10)),101)) END) AS VARCHAR(10)) AS DefaultValue
FROM UserProfile
WHERE UserID = @UserID
AND
PropertyDefinitionID = 215