How do I filter out / query all the commissions that's within the last month?

raelyn

I have a background task that's activated every 1st of the month to pay my affiliates a commission. How do I filter out / query all the commissions that's within the last month? Problem is that some months have 30 days, some months have 31 days, and so on...

Example:

On the 1st of October, I want to process all the commissions that came in from 1 Sept to 30 Sept.

On the 1st of November, I want to process all the commissions that came in from 1 Oct to 31 Oct.

And so on…

Pawel Magdanski

Hi,

I think you might want to look at this documentation regarding time&date transformation
https://docs.xano.com/working-with-data/timestamp

Especially here:
http://php.adamharvey.name/manual/kr/datetime.formats.relative.php

I think you need one of these transformations if I'm not mistaken

Hope that helps.

Louis Machado - CSA

Hi Raelyn

I recorded a video on how you can go about querying a table by a specific month.

https://www.loom.com/share/4f4d4290210d43e183a733e334bdffe6?sid=9d58e516-aa35-4444-9f5a-10b28095515e