Hi Julian -

If you want to do in between two dates then it should look like:

sum('4_Suppliers'['Order with supplier'.'Order date' >= 2021-03-01 and 'Order with supplier'.'Order date' <= 2021-03-31].'suma de compras')

For future thought, you may want to create a new formula field that just finds the month of the 'Order Date' field. So you would create a new formula field, call it MonthNum and put this in the formula:

month('Order date')

This will return the number 3 in your example. In the future you can do a search on MonthNum and you can find all March (3) records regardless of year.

Then this calls for making one for year as well, and we can do down the rabbit hole.

Let us know how it goes.

Well then the next step is for us to get a better understanding of your structure.

I'm guessing that '4_Suppliers' is a reference field in whatever table you are working in. The table '4_Suppliers' has another reference field to table 'Order with supplier'. The table 'Order with supplier' has a field called 'Order Date' that you are trying to use. Am I correct?

You can also email support@ninox.com and ask for access to the Webinar EN 2021 team and then you can upload the DB there.

I'm sorry to have jumped so quickly into other ways of doing dates when I don't have a good understanding of your structure. Looking back I may have over simplified things.

Again, I have led you down the wrong path. Sorry for not catching this earlier. Please see the corrected code below:

sum('4_Suppliers'.'Order with supplier'['Order date' >= date(2021,03,01) and 'Order date' <= date(2021,03,31)].'suma de compras')

As you can see we didn't "step down" far enough. The first time we stopped at '4_Suppliers', but we needed to link to 'Order with supplier' before we can do our filtering.

Then you just can't use date numbers as Ninox doesn't know how to translate them. Ninox actually stores the date you see in Order date as a number. So one way around it is to use the date function to tell Ninox you want it convert 2021,03,01 into numerical value of March 1, 2021.

Let us know if this works.