Date Comparison - How to deal with Dates?

Hi There !

I’m worried only about dates, no time consideration is necessary in this APP.
When I select a day and saves a date with “Date Time Picker” it also saves “current time”
Soon after, when I try to compare dates (put a data restriction in a RG) it considers the time, so nothing is selected…

Here is how data is saved in DB

Here is my selection
image

How to deal with that?
Supose I wanna select 06/29/2023, no time restrictions… How to save? How to retrieve?

Tks in advance !

Hi Augusto,

Just make sure that when you save the dates you use :rounded down to date:

And when you search in the contraints also use it:

That should work:

image

Hope this helps,

Gerbert
MVP Design

1 Like

Tks Very Much

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.