Last activity: 9 Oct 2017 5:59 EDT
Function to replace declare expression
I am referring property in report definition which is calculated through declare expression. because of which sorting and filter is not working on it.
I want to replace declare expression with function. Can someone help on how can i write function replace below declare expression condition?
.Age = @DifferenceinDays(.pyResolvedTimeStamp, @CurrentDateTime()) ---- if pyResolvedTimeStamp is not null
.Age = @CurrentDateTime() ---- if pyResolvedTimeStamp is null
Any suggestions are greatly appreciated.
***10/3/17 Edited by moderator, Maryrita: moved to Product Support from Applications***
***Edited by Moderator Marissa to update categories***