80 likes | 316 Views
What’s New in ACL v10. Presented by: Kim Tolliver. What’s First. Datetime data type. New Functions . Datetime Functions CMOY CTODT CTOT DATETIME – similar to DATE EOMONTH GOMONTH Splitting date – YEAR, MONTH, DAY Splitting time – HOUR, MINUTE, SECOND
E N D
What’s New in ACL v10 Presented by: Kim Tolliver
What’sFirst • Datetime data type St. Louis ACL Users Group
New Functions • Datetime Functions • CMOY • CTODT • CTOT • DATETIME – similar to DATE • EOMONTH • GOMONTH • Splitting date – YEAR, MONTH, DAY • Splitting time – HOUR, MINUTE, SECOND • Serial dates – STOD, STODT, STOT • System date/time – TODAY, NOW St. Louis ACL Users Group
New Functions • Other Functions • PI • SIN • COS • TAN St. Louis ACL Users Group
What’s Obvious • New Variables Tab St. Louis ACL Users Group
What’s Cool • Opening Multiple tables • Retaining filters • Extract View • Export to Multiple Tabs St. Louis ACL Users Group
What’s Helpful • Script Troubleshooting • Highlights where an error occurred • Can run step-by-step • Can specify “break” or stop point St. Louis ACL Users Group
What’s Exciting • New Command – EXECUTE St. Louis ACL Users Group