What's the opposite of the "week()" function

[Yann DIAB]

Hey, it's me again!

 

I have this project where i have a line with two dates. If the start date and the end date are not on the same week, i need to return the monday at 00:01 am and sunday at 11:59 pm between my two weeks for visualization purposes.

eg: if I start a work today and finish it next tuesday, I need it to return:

Sunday May, 22 11:59 pm

Monday May, 23 00:01 am

 

Thank you !