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

Get Help
1

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 .

Thanks!

2

Hi @ShunShun
You will have to do that in SQL until Metabase supports such functionality:
https://github.com/metabase/metabase/issues/16870 - upvote by clicking :+1: on the first post