How can I create a programmatic Search API query which uses a date field
Try

$myQuery-&gt;condition('field_application_end_date:value', '1411084800', '=');


Search API stores the dates as timestamps, so you're right there, but you forgot the 'value' after the field. If you want to use the 'to' date, use 'value2'.