I am trying to come up with a way to calculate a date based on another date already entered. Here is the scenario. Company A always pays on the 26th of every month for shipments based off of the previous month. So all orders placed in February, would then be paid on March 26th. Every order has a date ranging from the first of the month to the last as to when it shipped. Basically I would like to add another field to the Purchase Order table that shows the payment date of 3/26/2018 for all 2018 February orders. I have played around with DateAdd and Month/Day/Year, but have not come up with anything. Is there a simple solution to this?
Thanks in advance.