Advanced usage of Date syntax in Recurring Invoice

  • Updated

In Recurring Invoice, you have the option to use the DATE format keyword. The keyword is described here in details http://help.boyum-it.com/B1UP/recurringinvoicestemplates.html but here are a few samples of some more advanced use-cases: 

If you want to show a Quarterly Date Range you can write:

DATE[0.0.0.dd.MM.yyyy] - DATE[0.3.-1.dd.MM.yyyy]

Example:
On 1st of January 2017 this will result in "01.01.2017 - 31.03.2017"
On 1st of April 2017 this will result in "01.04.2017 - 30.06.2017"
On 1st of July 2017 this will result in "01.07.2017 - 30.09.2017"
On 1st of October 2017 this will result in "01.10.2017 - 31.12.2017"

If you want to show a monthly Date Range you can write:

DATE[0.0.0.dd.MM.yyyy] - DATE[0.1.-1.dd.MM.yyyy]

Example:
On 1st of January 2017 this will result in "01.01.2017 - 31.01.2017"
On 1st of February 2017 this will result in "01.02.2017 - 28.02.2017"

 

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.