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!
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.