How to format a search to ignore Saturdays and Sun...
# suiteflow
l
How to format a search to ignore Saturdays and Sundays? I'm creating a workflow to remind users if they have not logged time for the day before but want to exclude weekends. http://prntscr.com/ktbbqi
n
Use this formula in Formula (Numeric) field. CASE WHEN TO_CHAR({date},'D') = '1' OR TO_CHAR({date},'D') = '7' THEN 0 ELSE 1 ENDhttps://www.techonthenet.com/oracle/functions/to_char.php https://www.w3schools.com/sql/func_mysql_dayofweek.asp
👍 2