QueryTableRow - Filter by date

When I am passing the date field in a query to filter in querytablerow API as a string (example: 6/9/2022), it should ideally bring all values that have 6/9/2022 tagged in them in the date field, but it is not bringing any data. Do dates have to be sent in some specific format?

Hi @Nira-c595, thanks for your post! :honey_pot: :honeybee:

For a particular date in a FILTER formula, you'll use the 1900 Date System format. Meaning your formula may look something like this to return data with the 6/9/2022 date:
=FILTER(TableName, "TableName[Date]=%", "44721")

Or, you can reference a particular column in a table that already has the date data. For example:
=FILTER(TableName, "TableName[Date]=[ColumnOfDateToMatch]")

Hope that helps, and let us know if you have any other questions. :slight_smile:

@Alyssa Thanks for a quick reply. 1900 Date System Format worked perfectly.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.