Skip to content
Advertisement

specific day of next month on a sql query

I have a complex (complex because it gave me lots of work to complete!) and it returns results that fulfill the query till the day 30 of the current month.

Here is the code:

I have a job that runs this query on the third monday of every month.

What i need is that the query returns values not only till the 30th day of the current month but till the 10th day of the next month.

I’m a bit lost, can anyone give me a hint please?

Advertisement

Answer

It seems the shortest way would be to use EOMONTH function

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement