Hi!
You have to options:
1 - if you want to apply a specific format to all your date outputs, go to settings > dataview and change the output date format using luxon tokens.
2 - if you want to change a specific output in the query, use the function dateformat(field, "yyyy-MM-dd")
and use the luxon tokens.
For example, for the format “2021-09-10” use
dateformat(dateofpurchase, "yyyy-MM-dd")
… for “2021-Sep-10” use:
dateformat(dateofpurchase, "yyyy-LLL-dd")
Luxon tokens: luxon/formatting.md at master · moment/luxon · GitHub