Offset feature for the day option for a period

Hello,

I was looking to create a week report for sales on a supplier. This report would be issued every Monday and report on the previous weeks sales.

I looked under custom and other periods but I cannot OFFSET the days. I can OFFSET through a monthly setting.

Can we have the day periods have an OFFSET option?

Thank you,

Hi @TravisA,

Offset is there on a daily, if you create a new User Defined Period in the query screen, you should see it here:


Alternatively you could create a “defined period” type on the DB design:

Hope this helps,

Jon