Transaction Matching Custom report

Summary:

Hi Experts,

Need help with a requirement of custom query to display Start Date and End date in report such that the transactions are displayed accordingly for the entire month.

Content (required):

For e.g., 

Start Date: 01-06-2021

End Date: 30-06-2021

Ledger Balance as on 30-6-2021: 12345572

Our problem is the data is summing up day-wise when we enter date in dd-mm-yyyy but we need the data sum month-wise.

We were able to retrieve the data month-wise when we enter date in mm-yyyy format.

Version (include the version you are using, if applicable):

Oracle ARCS 21.11

Code Snippet (add any code snippets that support your topic, if applicable):