Set_query filter on date

Frappe Framework Custom Script
1 
cur_frm.set_query("shipment", function() {
      return {
          "filters": ["shipment", "date", ">", String(moment().format('YYYY-MM-DD'))]
      }
  });

I’m trying to filter a link by date (only future dates) and it can’t resolve it. My error reads:

1064, u'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'>, 2018-01-29 from `tabShipment` where `tabShipment`.`name` and locate("", `tabS\' at line 1')

Ideally, I’d like to do a between statement for the dates but I’m not quite sure how to make that work.

2

@tmatteson try below code

cur_frm.set_query("shipment", function() {
	return {
		filters:[
			['Shipment', 'date', '>', String(moment().format('YYYY-MM-DD'))]
		]
	}
});
3

Excellent! Thank you @rohit_w I swear I tried this syntax before and couldn’t get it working.
I was able to a second filter with the key value pair syntax as well:

cur_frm.set_query("shipment", function() {
				return {
					filters:[{'type': 'Air'},
						['Shipment', 'date', '>=', String(moment().format('YYYY-MM-DD'))]
					]
				}
      });