smartlist builder

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (3)

Answers (0)

WindyCityGP 1,051 on at

Like (0)

Report

RE: smartlist builder

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!
Community Member Microsoft Employee on at

Like (0)

Report

RE: smartlist builder

can you elaborate more please and thank you , can you write me the sql formula ?
PeterBurton 5 on at

Like (0)

Report

RE: smartlist builder

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?