AWS DynamoDB and Nodejs integration - how to filter between two dates?
<p>I have a small nodejs script connected to my DynamoDB and one of my primary sort keys is datetime, which is represented in UTC. </p>

<p>I would like to filter the results by a certain date and time and am having issues with my Filter Expression.</p>

<pre><code>var params = {
  TableName: "realtimeusers",
  ProjectionExpression: "brand, datetime, activeusers",
  KeyConditionExpression: "brand = :brand",
  FilterExpression: "datetime &gt; :today",
  ExpressionAttributeValues: {
    ":brand": "BRAND A",
    ":today": 1464705900
  },
};
</code></pre>

<p>I get the error message: </p>

<pre><code> "message": "Invalid FilterExpression: Attribute name is a reserved keyword; reserved keyword: datetime",
</code></pre>

<p>I think I am missing something in my filter expression that I don't fully grasp. </p>

<p>Can some one please help? </p>