Anyone have a formula to obtain the Monday of the current week?

decode (to_char({today},'D'),'1',{today}+1, '2', {today}, '3', {today}-1,'4', {today}-2,'5', {today}-3, '6', {today}-4,'7', {today} -5)

probably wrong somewhere.

Thanks man, this was extremely helpful. Tweaked it a bit, but this works.

CAST_TO_DATE(

DECODE(TO_CHAR(CURRENT_DATE,'D'),
       '1', CURRENT_DATE+1,
       '2', CURRENT_DATE,
       '3', CURRENT_DATE-1,
       '4', CURRENT_DATE-2,
       '5', CURRENT_DATE-3,
       '6', CURRENT_DATE-4,
       '7', CURRENT_DATE -5)
             )

if(yesterday == ‘Sunday’) return true; else return false;

This is smaller:

trunc({today},'DAY')+1

I don't understand why that would work

trunc basically truncates the date according to the parameter. The parameter ‘DAY’ is confusing, as it truncates the date to the first day of the week, giving you the date of the first day of the week. +1 just adds a day.

Very nice.

Weird, that's great. Helps cut down the enormous formula I'm having to use this criteria in.