Date query

[easygoingdave]

Hi
Is it possible to code the following:
An invoice is created with a textbox of =date(), Clients have varying due dates; 30, 60 and 90 days from the date of the invoice, easy to code =date()+30 etc. So far so good, However, here is the twisted, the due date days only start ticking: at the end of month in which the invoice was created' e.g.
Invoice created on the 15th Sept 15 with a due date of 60 days. The total number of days for the due date will be 75; 15 days to the end of the month plus the 60 days. Is it possible to code this on the invoice (report output).
Thanks in advance

 

[plog]

It would be best if you demonstrated what you wanted with data. Give us 2 sets:

A. Starting data from your table(s). Give us table and field names and enough data to cover all cases.

B. Expected results from your query based on data provided in A.

Use either a spreadsheet to upload data, or this format to just directly post data:

TableNameHere
Field1Name, Field2Name, Field3Name, ...
Ted, 5/11/2012, 76
Sally, 4/19/2008, 14
Bob, 4/1/2011, 99

Remember--2 sets of data, starting and expected results based on starting data.

 

[easygoingdave]

Plog
I think my post might have made it more complicated than it is. My firm produces weekly invoices for clients, rather than try and work out the due date i was hoping to have a field on the report that took the following into account:
Today's date; the number of days to the end of the month then add the 30, 60 or 90 days to provide a due date. When creating the invoice, i can identify whether it will be 30, 60 or 90 days. The difficult bit is identifying the current date and the number of days to the end of the month.
I hope this makes it clearer.
EasygoingDave

 

[plog]

To make it completely clear, follow the instructions in my first post.