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

I am very new to the sage report designer, I can find nowhere that explains the syntax for the expressions.
What I am looking to do is take the value of the 'ORDER_DATE', add one month to it and display this date value.

Looking at it I assume I will need to construct a statement that increases the Month value by 1, unless the value is 12 where it will change the month to 1 and increase the year by 1.
Do I need to create multiple expressions or..?


Dan

Hi Dan

It is just one rather long expression, "the date plus the number of days in the month".

something like this I expect...

AUDIT_HEADER.DATE+DaysInMonth(YearFromDate(AUDIT_HEADER.DATE),MonthFromDate(AUDIT_HEADER.DATE))

You need to change the Date to the one you want.