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 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.
André Arnaud de Cal... 290,554 Super User 2024 Season 2
Martin Dráb 228,588 Most Valuable Professional
nmaenpaa 101,148