question on "modification server datetime" and "creation ser

Classic Servoy
1

Hi,

i use “modification server datetime” and “creation server datetime” frequently in dataproviders.

But i really only need the date portion and not the time. So i like the time to be 00:00:00

If a user now searches on “14-11-2008” in such a field, no values are found,
because the date also has a time set, like 14-11-2008 12:34:23

With other datefields when i set the format to dd-MM-yyyy , the time is 00:00:00
and the user can search on those dates using a format like “14-11-2008”

Setting the format for a field wich has “modification server datetime” selected in dataprovider does
not set the time to 00:00:00.

Is there another way to set the time portion of these kind of dates to 0 ?

Regards,

2

One easy option would be to change the column type from DATETIME to DATE in your database, check your DB documentation for the details.