AnsweredAssumed Answered

Date Search problems

Question asked by stevenemms on Jan 23, 2015
Latest reply on Jan 30, 2015 by stevenemms

Title

Date Search problems

Post

When using scripts or performing a manual search I receive an odd issue with the date, this has only appeared since the start of 2015. The same thing happened last year with another database but resolved it by rebuilding. 

 

For example, I have a field for "InvoiceDate" when doing a manual search for "07/05/2013" (I have about 15 records that match that date) upon "Perform Find" I receive the "No records match this find criteria". When clicking Modify Find the search criteria now shows "* 07 2015 * 05 2015 * * 2013".

 

I have other date search in different tables that work fine!

Please help!

Thanks

Outcomes