Tim, Thanks...
I already tried using CAST, but that made no difference. I'll check out the other link, and revisit the CAST link. Steve -----Original Message----- From: Timothy Penner [mailto:[email protected]] Sent: Tuesday, July 10, 2018 1:18 PM To: [email protected]; 4D iNug Technical <[email protected]> Subject: RE: SQL Statement Assistance How about? - Using the TS syntax as described here: http://kb.4d.com/assetid=75947 - Using CAST to cast the TEXT as a Timestamp: http://doc.4d.com/4Dv15/4D/15/CAST.300-2288162.en.html http://kb.4d.com/assetid=75047 - Using a C_DATE variable instead of a _CTEXT variable -Tim Timothy Penner Senior Technical Services Engineer 4D Inc 95 S. Market Street, Suite #240 San Jose,CA 95113 United States Telephone: +1-408-557-4600 Fax: +1-408-271-5080 Email: [email protected] Web: www.4D.com ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
