Re: searching text for Date in dd/mm/yy format

2016-11-10 Thread Chip Scheide
I have resolved the issue by replacing the '/' with a '-' it did not take too long... and I am replacing the code that populates the fields to use a '-' rather then '/' so - solved On Thu, 10 Nov 2016 22:09:25 +0100, Keisuke Miyako wrote: > could you expand on the field type and the value

Re: searching text for Date in dd/mm/yy format

2016-11-10 Thread Chip Scheide
format of text is : dd/mm/yy at 00:00:00, User Name On Thu, 10 Nov 2016 22:09:25 +0100, Keisuke Miyako wrote: > could you expand on the field type and the value you know is there? > quick test shows that it should work as you would expect. > > ie. > >

Re: searching text for Date in dd/mm/yy format

2016-11-10 Thread Chip Scheide
v12 & v13 @ is wildcard so my original query is : find this date anywhere in the text No set query destination, I have even tried using 4D search editor - same results I have a way to 'fix' this problem. It is not pretty. something like : all records([table]) apply to

Re: searching text for Date in dd/mm/yy format

2016-11-10 Thread Charles Miller
On Thu, Nov 10, 2016 at 3:30 PM, Chip Scheide <4d_o...@pghrepository.org> wrote: > I am having problems being able to search for an embedded date. > Query([table];[table]track_field="@11/10/16@") > returns nothing, even though I can see that this value exists. > > I have tried using 2 // >

searching text for Date in dd/mm/yy format

2016-11-10 Thread Chip Scheide
I have a text field I use for tracking when an activity happens contains: User reference, Date, and Time I am having problems being able to search for an embedded date. Query([table];[table]track_field="@11/10/16@") returns nothing, even though I can see that this value exists. I have tried