DOB search result issue

Hello Brady,
In the Find by search filter, If we pass the DOB value 09/02/1978 and click on DOB, it gives the result.
But if the same value is passed and click on ANY filter it doesnot provide the results. Whereas it works good for other filters.
Can you please check whether it is an bug or not.

Thanks,
ViSolve

If you are searching using the ANY filter, you must enter DOB as YYYY-MM-DD, I have tried it multiple ways, including no symbols between the numbers. This is the only way I have found it to work.

It is the same way if you click on the patient tab and search via DOB there, although the DOBs are displayed as MM/DD/YYYY, the search must be entered as YYYY-MM-DD.

Hello @LollyPoppins,
As you say the format YYYY-MM-DD the results. But looks like a fix will be needed for this.

@Brady we shall make the required changes and commit.

Thanks,
ViSolve

1 Like

We did analyse more on this function and found this is what is exactly happening:

  1. When we enter any data in the search field and search by “Any Filter” the result is shown correctly because the search value entered and the data in Patient Table matches with each other.
  2. Whereas when we do the same with DOB, the result is not seen only because the format in the Database is “YYY-MM-DD” and the search format that we enter is “MM-DD-YYYY”. Since there is a mismatch in the format entered and the one saved, we are not retrieving the data.

Thanks,
ViSolve