Skip to content

DateTime filtering in transactions API #1988

@mimol91

Description

@mimol91

It seems that list transations https://docs.formance.com/api-reference/endpoints/ledger/transactions/list-transactions-from-a-ledger API incorrectly handles non UTC times

For example query

{
  "$and": [
    {
      "$lt": {
        "timestamp": "2026-05-21T15:09:13+04:00"
      }
    }
  ]
}

Should be interpreted the same as

{
  "$and": [
    {
      "$lt": {
        "timestamp": "2026-05-21T11:09:13Z"
      }
    }
  ]
}

However the API returns different results. It seems that the timezone information is skipped and 1st query is interpreted as "2026-05-21T15:09:13Z"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions