How to get current date with 0 hours and 0 minutes?

Wappler General Need Help
1

How to get current date (NOW) but with 0 hours and 0 minutes?

I'm trying to build a database query but one of the conditions has a problem:

Date vs Timestamp
2024-08-21 < 2024-08-21 12:30
This returns true, but I need it false, so the hour and minutes need to be 0, right?

2

You can format the date like:

NOW.formatDate('yyyy-MM-dd 00:00:00', false)
3

Thanks, I've settled for:

{{NOW.formatDate('yyyy-MM-dd', false)}}

It works. For anyone stumbling on this topic and thinks their query preview doesn't work, check this topic: