Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
As below.
Date(Floor([Adoption date])) as "Adoption date"
Thanks! That was easy 🙂
Appreciate your time