VbzCart/queries/qryCustAddrs

Details

 * Requires:
 * Used by:
 * Notes: Any basic simple calculations not involving other tables can be added to this query as needed.

SQL
CREATE OR REPLACE VIEW qryCustAddrs AS SELECT *, NOT ((IFNULL(WhenAct,Now) > Now) OR (IFNULL(WhenExp,Now) < Now)) AS isActive FROM cust_addrs;