So if I want the week to be Sunday through Saturda...
# generalr
rgoldstein
12/12/2019, 10:58 PMSo if I want the week to be Sunday through Saturday - looks like I gotta use a formula like the one you originally linked to
k
KevinJ of Kansas
12/13/2019, 11:59 AMYou could use decode, get today's day of week, and then subtract the right amount of days to get desired result and that would always be right...
KevinJ of Kansas
12/13/2019, 12:07 PMCase when {trandate} greater than ({today} - to_char({today},'d') -7) and less than ({today} -to_char({today},'d')-1) then {result} else 0 end
KevinJ of Kansas
12/13/2019, 12:09 PMGot halfway through typing it and realized I didn't need a decode haha
3 Views