Recurring invoice date variable

[DigitalCraft]

Hi,

I’m trying to set a recurring invoice to show on the description “From first day of next month to last day of the month”. The invoice will be sent every month on last week of the previous month and dates are for start and end of next month.

I.e. Invoice will be generated on the 27/07/2020 and description should show From 01/08/2020 to 31/08/2020.

||ENDMONTH+1|| works fine but can’t find a way to output first day of next month.

I’ve tried to play around with variable on the date variable test tool but no luck, has anyone managed to get this done?

Thanks in advance for the help!

David

[QFMathew]

Hi @DigitalCraft

This isn’t something that’s supported at the moment, although I agree this could be useful.

I have fed this back to our team.

[QFMathew]

Hi @DigitalCraft

Would something similar to this work for you?

||MONTHEND+1D|| - ||MONTHEND+1M-1D||

This would produce something like the following today (22/07/2020):

01/08/2020 - 31/08/2020

[DigitalCraft]

That works perfect!

Thank you

David