Date form and date to

what is the best way to retrieve data by specific date ,and must be the date from and   date to in the same month and same year 13/3/2023: Ex is correct: date from    date to: 28/3/2023   Ex is not valid Date from 13/3/2023 Date to 2/4/2023 Or  Date to 13/3/2024    
1 answers

You can use the formatDateTime function (this is for Mx 8, but in the Mx 10 documentation it is explained in more detail).

You could do something like formatDateTime($StartDate, 'MM/yyyy') = formatDateTime($EndDate, 'MM/yyyy')