how do i convert a qie date value to pass to sql server query

Question

I'm trying to pass the QIE channel variable  last_run with value  '20210508103020123' to a sql that expects a date value

SQL server is not recognizing the value as a date string

what needs changing..thanks in advance

Answer 1

You can format a date variable in QIE.

var myDate = qie.formatDate("yyyy-MM-dd", '20210508103020123');

Depending on the database field you may need a different format.