Hello everyone,
I am creating a BAQ where the expected date appears. I’m trying to add a set date for each Terms.
Other Terms were easily created. But, I ran into trouble setting the NML (last day of the following month) code. In the case of NML (last day of the following month) code, the date that is the last day of the following month of Duedate must appear.
For example, if Duedate is January 1st, January 15th, or January 31st, Estdate should be February 28th (29th if the last day of February is the 29th).
How can I make the field for the last day of the following month appear? What SQL should I put in the empty space in the screenshot below?
Thanks in advance!
