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:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to