Posted: 11 Mar 2019 11:12 EDT Last activity: 25 Mar 2019 10:44 EDT
Property Data type Conversion from Date to Date Time in Report Definition
I have the scenario to convert a value of a property of data type Date to DateTime in Report definition. Can I please know how can we convert this in Report definition. And, Please provide the steps to follow if possible.
Thanks for the Response. My usage of having the Date time in the Report definition is- I have a list of records to be filtered. My report definition contains few columns with date, date time properties. I wish to filter with the columns for a particular date. Here, my issue is the filter is not working for the columns of the properties of type date, and is working fine for the Date time property columns.
I have realized that both the columns with properties of type date and date time hold the datatype in DB as the time stamp. So, the filter is working fine for Datetime type properties but, not working fine for the Date properties because of the miss match of the datatype between Pega property and DB.
So, to achieve this filter criteria, I wish to convert the date to date time in the report definition itself. I have tried with gear icon next to column and convert date to date time, but it didn't work.