DateTime Picker includes current time even in "Date" only mode

Hey Backendless Team,

@James_Hereford and I are experiencing an unexpected issue with the DateTime Picker.

In our use case, we are using the DateTime Picker to select the start and end date for a where query. We want this search to be inclusive of the entire day from 00:00 to 23:59. We have discovered that the DateTime Picker includes the current time (when the picker is filled) in the timestamp even when only “Date” is selected in the options.

For example, if we set our start date to 9/8/2024 using the DatePicker (and the current time was 13:05) the time stamp will read 9/8/2024 at 13:05. The DateTime Picker takes the current time when the picker is being filled and passes that into the time stamp.

This means that the “Start Date” now excludes any entries that happened on 9/8 before 13:05.

Ideally, we would like the datetime picker to output the time 00:00 for 9/8.

Currently, we are using a variable to calculate the current time in milliseconds and then subtracting that from the value provided but the datetime picker, however this is not ideal.

Do you have any recommendations as to how we can get our expected output from the datetime picker?

Hello @Bradd_Schofield

I could advice the next approach:

image