Capture the date when a record was saved to the report DB table

General
,
1

In an activity, first i’m calling a report definition to set the parameters needed to fetch a report. Then, i’m calling an API’s data source, a data transform, to update the DB table (which stores the data for the required report) using the data i get from the report definition.

I have a requirement to capture the date when a record was saved to the report DB table, but I’m not sure how to do it. Can someone help me out?

2

@Ebhavya

Please check pxCommitDateTime. That should give you the date time stamp when the data was save into the table.

3

@Ebhavya

While storing or saving the data in DB, Add another property to save the current date time in the DB, or else you can simply take the pxCreateDateTime from the records in DB