Display Last Date in Month on Report

Marcus H

Registered User.
Local time
Today, 23:03
Joined
Nov 29, 2000
Messages
13
My report creates an invoice for account customers. On my invoice i would like it to automatically say when payment is due. Payment is due on the last day of the month in question. So if we are in March it should say payment due 31st March. What criteria expression would i need to implement this and can i do it straight into the report rather than add an extra field to my query? Thanks for any tips!
 
Compute the first day of the next month, then subtract 1 day.
 
The following article contains the expression you need and yes you can use it on the report without adding to the query
Article ID: Q88657
 

Users who are viewing this thread

Back
Top Bottom