This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi everyone,

I’m creating a saved search and I’m looking for a formula to return just the Monday date that a transaction date falls in.
For example:
A transaction date of 9/1/2021 would return  “8/30/21”
A transaction date of 8/24/2021 would return “8/23/21"

Thanks for you help all.

```CASE 
WHEN TO_CHAR({date},'D')=3  THEN to_char(({date}- 1), 'MM/DD/YYYY') 
WHEN TO_CHAR({date},'D')=4  THEN to_char(({date}- 2), 'MM/DD/YYYY')
WHEN TO_CHAR({date},'D')=5  THEN to_char(({date}- 3), 'MM/DD/YYYY')
WHEN TO_CHAR({date},'D')=6  THEN to_char(({date}- 4), 'MM/DD/YYYY')
WHEN TO_CHAR({date},'D')=7  THEN to_char(({date}- 5), 'MM/DD/YYYY')
WHEN TO_CHAR({date},'D')=1  THEN to_char(({date}- 6), 'MM/DD/YYYY')
ELSE to_char(({date}), 'MM/DD/YYYY')
END```

Thanks for the response <@U027PS9BDU2>! I also found another way using the nextday function.

NEXT_DAY({trandate},‘SATURDAY’)-5