Hi! It sounds very easy but I can't get it work. I'm trying to get the latest records of the current week where to extract the Monday date from the snapshot Date but if the mondate date is not available like 06/23 , I'd like to extract the SUN or tues or whatever is the latest.
I tried using the formula where Snapshot Week = snapshot Date or Snapshot Week = min (snapshot Date) but doesnt work.Also, tried using where Snapshot_Week = min(Snapshot_Date) , doesnt work either
Snapshot Week snapshot Date
06/16/2014 06/16
06/16 06/17
06/16 06/18
06/16 06/19
06/16 06/20
06/16 06/21
06/16 06/22
06/23/2014 06/24
06/23 06/25
06/23 06/26
06/23 06/27
06/23 06/28
My desired results :
Snapshot Week snapshot Date
06/16/2014 06/16
06/23/2014 06/24 since 06/22 and 06/23 is not available
Thanks in advance.
