This week and Last week set criteria when week starts on Monday?
I live in a country when weeks starts on Monday.
For Last week I applied this set criteria
- (Added_Time >= zoho.currentdate.subDay((zoho.currentdate.getDayOfWeek() + 6)) && Added_Time <= zoho.currentdate.subDay(zoho.currentdate.getDayOfWeek()))
For This week I applied this set criteria
- (Added_Time >= zoho.currentdate.subDay((zoho.currentdate.getDayOfWeek() - 1)) && Added_Time <= zoho.currentdate.addDay((7 - zoho.currentdate.getDayOfWeek())))
This scripts work when weeks starts on Sunday. How should I modify this set criteria when weeks starts on Monday?
Thanks anyone who can help!