Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a variable and added the below expression, somehow it isn't giving all the distinct sso's what I needed.
Variable1=concat({$<[Last Login Date]={"$(today()-30)"}> DISTINCT SSO,';')
Basically I wanted those sso's where today()-Last Login Date] >=30
Once the above condition satisfies, it will sent mail to only those sso's in the organization.
='mailto:'&Variable1&' & ?subject = Report Last Used '&[Last Login Date]&'
Let me know your thoughts?
Try this Put "$( )" around your reference to Variable 1 as shown below:
='mailto:'& $(Variable1) &' & ?subject = Report Last Used '&[Last Login Date]&'
You might also want to change "today()" to "today(1)" in your variable so that it picks up the current date... if that's what you're after.
Also, make sure that your variable content doesn't start with "=".
Let me try that but I think my variable expression is also wrong, it is not giving me the list of ssoid
concat({$<[Last Login Date]={"$(today()-30)"}> DISTINCT SSO,';')
I am trying to take only those SSO's if Today() - Last Login Date > 30