Hi all,
I have a date field Payment Date and i am created the calender object on top of the field.
Now user selects a date range from and to date through calender object
But the issue is Payment Date field having some nulls replaced with 'Not paid'. if user selects any date range that data should be visible+'Not paid' data is also visible for any date range selection.
For this scenario calender object will not select the string so i want to use this calender object for only to store date values in the variable
i want to use this variable in straight table expression.
now i need the expression based on my requirement.
that expression is having to select the data from with in a selected date range and also pick the string Not Paid