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 selection([table];[table]track_field:=replace string([table]track_field;"/";"-") On Thu, 10 Nov 2016 15:35:11 -0500, Charles Miller wrote: > 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 // >> 10//11//16 >> and 3 /// >> 10///11///16 >> >> any Ideas? >> > > have you set query destination somewhere and not reset to current selection > > you could also try > begin sql > > select [key field] > from [table] > where [table].[track_field] like '11/10/16' > into :$Keyflds_atxt; > > end sql > What version and how is wild card "@" set to be used > > Regards > Chuck > > > -- > ----------------------------------------------------------------------------------------- > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D, Sybase & SQL Sever connectivity > http://www.informed-solutions.com > ----------------------------------------------------------------------------------------- > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption > from disclosure as to this communication. > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************