How to add a transformation to convert a timestamp field to %Y-%m-%d format in a dataset
Hey folks. I have a created_at column in my dataset which is in timestamp format. I want to add another field created_at_utc and convert it to %Y-%m-%d format. How can I add the transformation?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.
What if you first convert it into string in your jinka expression?
<@U065RJ879QT> Then it throws 'str object' has no attribute strftime .
huh. Well clearly the problem is that builder does not recognize your timestamp as datetime, but I have not seen this problem before. One sec, will ask the team.
Yes. it is recognising it as an integer. Please do ask the team, its becoming a bottleneck.
yes. when I use '{{ record.created_at.strftime("%Y-%m-%d") }}' , it throws 'int object' has no attribute 'strftime' .
Are you using the connector builder?