Subject Re: Like query From Tom <IHaveNoEmail@ddress> Date Thu, 26 May 2022 08:02:48 -0400 Newsgroups dbase.getting-started Attachment(s) Like_Search1Form.png, CommandWindow.png On 5/26/22 4:01 AM, Mervyn Bick wrote: > On 2022/05/25 17:35, Tom wrote > >> See NewInvoiceEntries image for additional table entries I made >> sometime in the past. >> > .....> >> See CastDateEntry image for dBase's exception to your mm/dd/yyyy >> statement. Explains why I could not find my '04' date entries. > > > Strange.  This may be due to a global setting but with date set AMERICAN > on my computer the leading 0 appears in both the 'order date' and the > cOrder fields.  I normally use the YMD date format and the cast() field > shows the leading 0 as well.   See the screenshots attached. > > To see what cast() produces on your computer enter the following in the > Command Panel while the like_search1.wfm is open. > > open database dbasetutorial > select i.'order date',i.cOrder from :dbasetutorial:invoice i > browse > use //to close the workarea once you have examined the table. > As instructed ... I specialize in strange :) Tom