Search date

Discuss the database features
Post Reply
dreamquartz
Posts: 881
Joined: Mon May 30, 2011 4:02 am

Search date

Post by dreamquartz »

Hi All,

I am trying to figure out why I cannot search on date format MM-DD-YYYY, while the date in the table is formatted as MM-DD-YYYY.
I have a form that allows to enter the DOB in that order, and it is represented the same way.

The format for Search must be: YYYY-MM-DD, and I cannot seem to change that.
Any idea where I can find some info on this?
I seem not to be able to find anything.

Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Top
Post Reply

Return to “Base”