Using pipelines to log the date/time including the seconds of a record change

Question

I have a pipeline that logs when a record was changed in a tracker table. I need the date/time of the change to be accurate to the second.

I can't have a pipeline copy the Date Modified of the source record to a Date/Time field in the status change record as we would lose the seconds.

I can't use the Date Created of the record created by the pipeline as this and the user's action are offset by a second or two. I need this to be when the user made the change, not when the pipeline created the record.

I created a Formula - Date/Time field in the source table that is ToUnixTime([Date Modified]), then the pipeline copies that to a Number field in the status change record. This works, however I'm in search of a more elegant solution than creating a formula field in every table that needs this.

Is there a Jinja expression that will give me the ToUnixTime() of Date Modified without having to create a formula field?

Best answer by hiker85

Found a solution:
{{a.updated_at.timestamp() * 1000 }}

hiker85 · Accepted Answer

Found a solution:{{a.updated_at.timestamp() * 1000 }}

Sign up

Login to the community