How to get last 13 months data start from current data

Hello outsystems teams

Please let me know how to get the last 13 months data start from current date.

For example current date  is 2020/07/20 so I want to get data from 2020/07/20 ~ 2019/07/20.

How to implement this Please help me.

Thanks

Hi May,


Use addmonths built functions available in outsystems, like this addmonths(currdate(),-13) and query your table. Hope this will help you.


Regards,

Koushik