<@UCEE9298V> 1. Navigate to Lists &gt; Search &gt;...
# general
s
@Kyle 1. Navigate to Lists > Search > Saved Searches > New > Transaction 2. Under the Criteria tab > Standard sub tab, select Type and set it to the transaction type you want to view. 3. Under the Results tab > Columns sub tab: Select Formula (Text) for the age of transaction excluding weekends in Days-Hours- Mins format and use the formula below (TRUNC(To_Char({today}-{datecreated})))-((((TRUNC({today},'D'))-(TRUNC({datecreated},'D')))/7)*2) - (CASE WHEN TO_CHAR({datecreated},'DY')='SUN' THEN 1 ELSE 0 END) - (CASE WHEN TO_CHAR({today},'DY')='SAT' THEN 1 ELSE 0 END)||' days '|| TRUNC(MOD(({today}- {datecreated} ) ,1)*24) || ' hrs ' || TRUNC(ROUND(MOD(MOD(({today}- {datecreated} ) ,1)*24,1)*60),2) || ' mins' Select Formula (Numeric) for age of transaction excluding weekends in raw number format(rounded to two decimals) and use the formula below ROUND(((To_Char({today}-{datecreated})))-((((TRUNC({today},'D'))-(TRUNC({datecreated},'D')))/7)*2) - (CASE WHEN TO_CHAR({datecreated},'DY')='SUN' THEN 1 ELSE 0 END) - (CASE WHEN TO_CHAR({today},'DY')='SAT' THEN 1 ELSE 0 END),2)