in Trello csv export doesn't have card added dates

[Brendan Coon]

I want to export by board with a column for when a card was added, or created, or whatever it's called in the backend.

The only data available is last activity, which is useless for my purpose, which is to track how many cards we added this quarter. Is there a way to get this in an export? Thanks!

[milynnus]

@Brendan Coon learned this recently. The first 8 characters of the card id can be used to get the card created date.

Card ID	=left(B2,8)	=hex2dec(C2)	=D2/86400+DATE(1970,1,1)+time(5,30,0)
5f8959abd072dc81627034c3	5f8959ab	1602836907	10/16/2020 13:58:27

[George Brindeiro]

Nice! Super helpful information, thanks!

If someone wants the final formula, assuming Card ID is in cell A2:

=(HEX2DEC(LEFT(A2,8)))/86400+DATE(1970,1,1)+time(5,30,0)

[Bingham Compton]

=(HEX2DEC(LEFT(A2,8)))/86400+DATE(1970,1,1)+time(5,30,0)
Yes this works well,
Big Thank you for sharing :-)