Mysql query needed for problem

[Prof.Merlin]

Hi

Basically what I need is a query that returns the month. If the query is fun before the 26th of June, it should report back the last date was 26 of May. If it was done after the 26th of June, it should return back the 26th of June.

So it should always report back the last months 26th day.

Hope that makes sense :/

Tx!

 

[@udiS3]

CREATE DEFINER=`root`@`%` PROCEDURE `GetFinancialDate`()
BEGIN
if Day(NOW())>25 then
select NOW();
else
select DATE_SUB(NOW(), INTERVAL 1 MONTH);
end if;
END

call GetFinancialDate();

 

[Prof.Merlin]

Thanks for your help. That puts me on the right path. Will tweak it where needed.

 

[@udiS3]

Welcome!

 

[dadecoza]

using @udiS3 logic but without the need for a storedproc ...

select if (Day(NOW())>25,NOW(),DATE_SUB(NOW(), INTERVAL 1 MONTH)) as test;