PeopleSoft query expression to calculate age on SQL server

Question

Post reply

PeopleSoft query expression to calculate age on SQL server

khandwerk582

SSC Veteran

Points: 236
More actions
April 16, 2015 at 9:39 am

#306986

I have been trying to calculate age and the results either round the age up one year or down one year. I have tried CASE, DATEDIFF, FLOOR functions but nothing helps. Any advice would be greatly appreciated!
KH

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Check out this article and see if it helps: http://www.sqlservercentral.com/articles/T-SQL/63351/.

khandwerk582 SSC Veteran Points: 236 More actions · Answer 2

khandwerk582

SSC Veteran

Points: 236

April 16, 2015 at 11:47 am

#1791441

Unfortunately I cannot get this to work

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

khandwerk582 (4/16/2015)
Unfortunately I cannot get this to work

Sorry, I don't have a crystal ball. Without more information there really is nothing we can do except shoot in the dark and hope we help. Can you elaborate on what it is you are doing and why the article didn't help?