date field are not searchable in the correct format?

PHPMaker General Discussion (PHPMaker)
1

hi,

in my database, my date field is stored in the format “2020-06-15” (mysql)
on screen my date field is in a lookup table field (display field #1), the display format is “15/06/2020” (in france it is the way)
when i active the search option in the modal list, then i discovered i had to enter the string in the database format to make the search works !
if i enter 2020, ok it is works
if i enter 15/06, there is not result
if i enter 06-15 there is the result
is it normal or i miss somewhere a parameter in phpmaker ?

and

i also noticed the same “bug” append on the quick search in list view page.
moreover, i also noticed in the result of the quick search, the format (from the result line) is not the display format before i do the search.

Best regards

2

amiens80 wrote:

is it normal or i miss somewhere a parameter in phpmaker ?

I think so.

3

hi,

i’m not sure i understand all.

in quicksearch, do we have to enter a “regional formated date” or " native stored database" format or “what you see in the cell” date ?

quicksearch seem to have its way
modal list have its own different way
filter (table setup) have it own way too
…

it is quite confusing…

4

amiens80 wrote:

n quicksearch, do we have to enter a “regional formated date” or " native stored
database" format or “what you see in the cell” date ?

You’d better enter in “native stored database” format.