Need Help In Dates [message #669399] |
Sat, 21 April 2018 18:08 |
Djpats
Messages: 17 Registered: January 2018
|
Junior Member |
|
|
hi guys.
how do i calculate below dates i.e every monday to thursday
Summary of Credit Note requested from Monday (DD/MM/YYY) to Thursday (DD/MM/YYYY) :
any help will be appreciated
pfa,
i have added screen of my requirment
thank you in advance
|
|
|
|
|
Re: Need Help In Dates [message #669402 is a reply to message #669399] |
Sat, 21 April 2018 20:20 |
Solomon Yakobson
Messages: 3275 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
It is not clear what exactly you mean by "monday to trursday". I will assume Monday, 00:00:00 - Thursday 23:59:59:
where dt >= trunc(dt,'iw')
and dt < trunc(dt,'iw') + 4
SY.
|
|
|