If Dates were stored in varchar Datatype that would work as expected, but in my case the dates are stored in Date type hence cant be used in default concatenate function, so i want to write my own function alias to concatenate dates but having struggle in coding part.
1) Include both the columns in the report definition which holds the from and to date column values.
2) Check the hide checkbox on both the properties in the display columns of the report definition.
3) write a function on a third property like pyNote which also has to be included in the RD. This function should be capable of reading the value from both the date properties and concatenate them as required. This is possible if the RD is running on a Pega table and not any external table. Also you might not be able to perform any type of sorting on this property when it is displayed.