RE: SQL Statement Assistance

2018-07-10 Thread Timothy Penner via 4D_Tech
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 *

RE: SQL Statement Assistance

2018-07-10 Thread Stephen J. Orth via 4D_Tech
iNug Technical <4d_tech@lists.4d.com> 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

RE: SQL Statement Assistance

2018-07-10 Thread Stephen J. Orth via 4D_Tech
ecifically trying to query against both date & time. Steve -Original Message- From: Timothy Penner [mailto:tpen...@4d.com] Sent: Tuesday, July 10, 2018 1:18 PM To: s.o...@the-aquila-group.com; 4D iNug Technical <4d_tech@lists.4d.com> Subject: RE: SQL Statement Assistance How abou

RE: SQL Statement Assistance

2018-07-10 Thread Timothy Penner via 4D_Tech
There may be multiple things wrong here; First, is your field actually named TimeStamp? If so, this is a SQL Reserved word and shouldn’t be used as a field identifier. Let's start with that first. -Tim ** 4D Internet Users G

RE: SQL Statement Assistance

2018-07-10 Thread Stephen J. Orth via 4D_Tech
eve -Original Message- From: Timothy Penner [mailto:tpen...@4d.com] Sent: Tuesday, July 10, 2018 1:44 PM To: s.o...@the-aquila-group.com; '4D iNug Technical' <4d_tech@lists.4d.com> Subject: RE: SQL Statement Assistance There may be multiple things wrong here; First, is your f

Re: SQL Statement Assistance

2018-07-10 Thread Charles Miller via 4D_Tech
ry if fine. > > My problem is now trying to make the static timestamp values being queried > on dynamic. > > > Steve > > -Original Message- > From: Timothy Penner [mailto:tpen...@4d.com] > Sent: Tuesday, July 10, 2018 1:44 PM > To: s.o...@the-aquila-group.com; 

RE: SQL Statement Assistance

2018-07-10 Thread Justin Will via 4D_Tech
Steve Try removing the single quotes in your text variable assignment and retry your initial example. Justin ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html

RE: SQL Statement Assistance

2018-07-10 Thread Timothy Penner via 4D_Tech
That looks like the field is just plain text; have you tried just removing the extra single quotes from the text variable in your initial example (Justin Will also suggested this)? vt_temp1:="04/06/2018 07:58:00 AM" vt_temp2:="04/06/2018 08:01:00 AM" Begin SQL SELECT Recor

RE: SQL Statement Assistance

2018-07-10 Thread Stephen J. Orth via 4D_Tech
ical <4d_tech@lists.4d.com> Subject: RE: SQL Statement Assistance Steve Try removing the single quotes in your text variable assignment and retry your initial example. Justin ** 4D Internet Users Group (4D iNUG) FAQ: http:

RE: SQL Statement Assistance

2018-07-10 Thread Stephen J. Orth via 4D_Tech
* -Original Message- From: Timothy Penner [mailto:tpen...@4d.com] Sent: Tuesday, July 10, 2018 3:09 PM To: s.o...@the-aquila-group.com; '4D iNug Technical' <4d_tech@lists.4d.com> Subject: RE: SQL Statement Assistance That looks like the field is just plai

RE: SQL Statement Assistance

2018-07-10 Thread Stephen J. Orth via 4D_Tech
Original Message- From: Timothy Penner [mailto:tpen...@4d.com] Sent: Tuesday, July 10, 2018 1:18 PM To: s.o...@the-aquila-group.com; 4D iNug Technical <4d_tech@lists.4d.com> Subject: RE: SQL Statement Assistance How about? - Using the TS syntax as described here: http://kb.4d.com/assetid=