SageForum for UK versions of Sage 50- Help and support.

I hope it does.... "For the period 01/02/2016 to <invoicedate>"

If you have problems let me know

Hi

I Created an invoice dated 08/03/16, using the formula below it came up with 01/03/16 to 08/03/16, so how can we make it go to the end of the month?

Regards

Stephen

substring(DateTimeToString(CreateDateTime(YearFromDate(INVOICE.INVOICE_DATE), MonthFromDate(INVOICE.INVOICE_DATE),1)), 1,10) + " to " + substring(DateTimeToString(INVOICE.INVOICE_DATE),1,10)

You could try setting the date to the first of next month and then taking one day away, I have not tried this but I am thinking something like this might work... I would test it over a year end as month 12 + 1 might break things, not sure, you have to try and see...