timestamp to DATE

bok

hi im triying to generate an api call but as known date fields are always answered in timestamp format , i would like to transform this on the response i know update variable would work but i'm stuck on how it would work on a response that has 5000 answers so i need a function that does this for every object

im not using this for a front but to create a csv so i need date to be more readable

Pawel Magdanski

Hi,

One of the options is to make a loop through the list. Use the update variable to create a new field in the object with your timestamp value and then perform a format_timestamp filter on this timestamp with the format that suits you best. for 5000 records it might take some time though.

How often do you need to do this?

bok

Thanks for your response it would be every hour and those 5000 record will get bigger with time 200 a day increase so yes im also concerned this might become a heavy task, also its not just one stamp "column" or objects its 5 in total