Subject Re: Like query From Tom <IHaveNoEmail@ddress> Date Thu, 26 May 2022 16:57:12 -0400 Newsgroups dbase.getting-started Attachment(s) Cast.png On 5/26/22 4:38 PM, Tom wrote: > On 5/26/22 3:29 PM, Mervyn Bick wrote: >> On 2022/05/26 14:02, Tom wrote: >>> As instructed ... >>> >>> I specialize in strange :) >>> >>> Tom >> >> Most peculiar. :-( >> >> Try un-commenting the XDML code in the header section of >> like_search1.wfm and use DTOC() instead of cast() to populate the >> cOrder field. >> >> Mervyn. > * > As instructed ... > > Date search works like a charm as long as you remember to include the > leading zero for months less than October. :) > > Thank you, > > Tom * As I read the enclosed Local SQL Help file excerpt, you should be able to 'cast' the 'Order Date' field *directly* to a string as opposed to creating a new field and without permanent damage to the original date values. Is this possible? Tom