Python code -
paramsDict = {'USdateFrom':Rdate.getUSFormatDateOnly(dateFrom,Rdate.MEDIUM),'USdateTo':Rdate.getUSFormatDateOnly(dateTo,Rdate.MEDIUM)}
Rutilities.debug(Rdate.getUSFormatDateOnly(dateFrom,Rdate.MEDIUM))
dao = thisApplication.executeQueryFromDatasource("SQL server query file",paramsDict)
This code calls file which has below sql.
SQL server code - SQL server query file
SELECT * from <Table>
WHERE
CONVERT(VARCHAR,CAST(TABLE_DATE AS DATETIME),101)
BETWEEN
CONVERT(VARCHAR,'USdateFrom',101)
AND
CONVERT(VARCHAR,'USdateTo',101)
Query - USDateFrom and USdateTo in SQL does not work. No error. We use Reliance ETQ Product.