How to modify date/time in table?

[Breezy]

For my table I would like the "Adoption date" to only state the actual date, not the time. For example, for Frog, how can I remove 7:45:45 PM?

Animal	Adoption date
Frog	12/9/2021 7:45:45 PM
Rabbit	4/4/2022 7:24:45 PM

[BrunPierre · Accepted solution]

As below.

Date(Floor([Adoption date])) as "Adoption date"

[Breezy]

Thanks! That was easy 🙂

Appreciate your time