How to convert date format, eg: "1900-01-01" to "0"

In Pivot Table, I can't use the DATEDIFF function to calculate the number of days, so I use something like
"=Min([T → Fdate]) - Max([T → Fdate])" gets "1900-01-01T00:00:00+07:36:42", how do I convert it to days:"0"?

BTW:I don't want to use native query question for pivot table .


Hi @ShunShun
You will have to do that in SQL until Metabase supports such functionality: - upvote by clicking :+1: on the first post