[HOLD for payment 2024-12-17] [Search v1.2] Add date-based filter for report actions

[luacmartins]

Coming from the design doc, the intended design is that we more broadly have date filters for report actions. In particular, this means search syntax for:

• submitted:
• approved:
• paid:
• and exported:

These queries will accept dates in the YYYY-MM-DD format.

Note: some report actions can be undone (submission, approval, payment), or can happen multiple times (approval, export). As a result, we’ll filter on the date corresponding to the last report action. In the case of approvals, it’s the last report action corresponding to final approval.

Issue Owner

Current Issue Owner: @JmillsExpensify

[melvin-bot]

Triggered auto assignment to @adelekennedy (NewFeature), see https://stackoverflowteams.com/c/expensify/questions/14418#:~:text=BugZero%20process%20steps%20for%20feature%20requests for more details. Please add this Feature request to a GH project, as outlined in the SO.

[melvin-bot]

⚠️ It looks like this issue is labelled as a New Feature but not tied to any GitHub Project. Keep in mind that all new features should be tied to GitHub Projects in order to properly track external CAP software time ⚠️

[melvin-bot]

Triggered auto assignment to Design team member for new feature review - @dubielzyk-expensify (NewFeature)

[JmillsExpensify]

Coming from the design doc, the intended design is that we more broadly have date filters for report actions. In particular, this means search syntax for:

• submitted:
• approved:
• paid:
• and exported:

These queries will accept dates in the YYYY-MM-DD format.

Note: some report actions can be undone (submission, approval, payment), or can happen multiple times (approval, export). As a result, we’ll filter on the date corresponding to the last report action. In the case of approvals, it’s the last report action corresponding to final approval.