Announcements
hi guys ,
i am trying to add a cloumn to smartlist where calculated field = todays date - document date , any insight would really help i have tried this following formula but its not working please refer to the screen shot
*This post is locked for comments
Hi,
I used the DATEDIF function to calculate a person's age. I have it return the # of days and then divide that by 365.
DATEDIFF ( day , {Payroll Master:Birth Date} , GETDATE() )/365
Hope this helps!
can you elaborate more please and thank you , can you write me the sql formula ?
We have done this in Smart List Builder, but only by using SQL directly. If you know the underlying tables can you just use a datediff function in SQL to acomplish this?
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156