This content has been marked as final. Show 6 replies
in my calendar do I have an 'InvoicePeriodCounter' and every month has two invoice periods.
Though I want to show current month -1 it doesn´t work over the year end.
How do I create the counter for the month over all years?
[Flag] as [Flag1],
[InvoiceMonthNum] as [InvoiceMonthCounter],
recno() as [InvoicePeriodCounter]
order by [Flag] asc;