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 RecordID, Mach_ID, Energy_1, Energy_2, Energy_3
FROM DMM_TTX_HISTORIAN
WHERE TimeStamp >= :vt_temp1
AND TimeStamp <= :vt_temp2
INTO :al_temp1, :at_temp1, :ar_temp1, :ar_temp2,
:ar_temp3
End SQL
-Tim
**********************************************************************
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]
**********************************************************************