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
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (