smartlist builder

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (0)

PeterBurton 5 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

can you elaborate more please and thank you , can you write me the sql formula ?

Was this reply helpful? Yes No
WindyCityGP 1,069 on at

Like (0)

Report

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!

Was this reply helpful? Yes No