G Gav White Registered User. Local time Today, 16:59 Joined Jul 16, 2003 Messages 12 Aug 19, 2003 #1 Hi All Is it possible to use a LIKE statment in SQL which will search for Partial Dates, I've been trying but it just bugs out. Any advice?
Hi All Is it possible to use a LIKE statment in SQL which will search for Partial Dates, I've been trying but it just bugs out. Any advice?
W WayneRyan AWF VIP Local time Today, 16:59 Joined Nov 19, 2002 Messages 7,122 Aug 19, 2003 #2 Gav, You're probably going to have to use the DatePart function to accomplish this. See the Help files or use the Search facility here. Wayne
Gav, You're probably going to have to use the DatePart function to accomplish this. See the Help files or use the Search facility here. Wayne
N namliam The Mailman - AWF VIP Local time Today, 17:59 Joined Aug 11, 2003 Messages 11,695 Aug 19, 2003 #3 Or use functions like Day Month Year Or if you do Format(YourDate, "dd-mm-yyyy") it turns your date into a string and you can "Like" all you want Regards
Or use functions like Day Month Year Or if you do Format(YourDate, "dd-mm-yyyy") it turns your date into a string and you can "Like" all you want Regards
G Gav White Registered User. Local time Today, 16:59 Joined Jul 16, 2003 Messages 12 Aug 19, 2003 #4 Thanks for the advice, ill get onto it. Cheers
