文件名称：BOS V6.2开发指南_扩展报表函数参考手册
文件大小：992KB
文件格式：PDF
更新时间：2017-03-29 14:44:36
EAS BOS 开发指南 java
1 公式向导 ...................................................................................................................................... 4 2 函数参考 ...................................................................................................................................... 6 2.1 数据集函数 ......................................................................................................... 6 2.1.1 数据集函数 ......................................................................................................... 6 2.1.2 DISTINCT ........................................................................................................... 7 2.1.3 ENUMGROUP .................................................................................................... 7 2.1.4 Field ..................................................................................................................... 8 2.1.5 Fields.................................................................................................................... 8 2.1.6 FIRST .................................................................................................................. 9 2.1.7 Group ................................................................................................................... 9 2.1.8 LAST ................................................................................................................. 11 2.1.9 LIST ................................................................................................................... 11 2.1.10 NULL ................................................................................................................. 12 2.1.11 OVERLAP ......................................................................................................... 12 2.1.12 SELECT ............................................................................................................. 13 2.1.13 SELECT1 ........................................................................................................... 14 2.1.14 SELECTEX ....................................................................................................... 14 2.1.15 SORT ................................................................................................................. 15 2.1.16 TO ...................................................................................................................... 15 2.1.17 V ........................................................................................................................ 16 2.2 日期时间函数 ................................................................................................... 16 2.2.1 日期时间函数 ................................................................................................... 16 2.2.2 DATE ................................................................................................................. 17 2.2.3 DATEDIF ........................................................................................................... 17 2.2.4 DATETIME ....................................................................................................... 19 2.2.5 DATEVALUE .................................................................................................... 19 2.2.6 DAY ................................................................................................................... 20 2.2.7 DAYS360 ........................................................................................................... 20 2.2.8 HOUR ................................................................................................................ 21 2.2.9 MINUTE ............................................................................................................ 21 2.2.10 MONTH ............................................................................................................. 21 2.2.11 NOW .................................................................................................................. 21 2.2.12 SECOND ........................................................................................................... 21 2.2.13 SETHOLIDAY .................................................................................................. 22 2.2.14 SETWORKDAY ................................................................................................ 22 2.2.15 SETWORKTIME .............................................................................................. 23 2.2.16 TIME.................................................................................................................. 23 2.2.17 WEEKDAY........................................................................................................ 23 2.2.18 WORKTIME ..................................................................................................... 24 2.2.19 YEAR ................................................................................................................ 25 2.2.20 YEARFRAC ...................................................................................................... 25 2.3 数学和三角函数 ............................................................................................... 26 2.3.1 数学和三角函数 ............................................................................................... 26 2.3.2 ABS.................................................................................................................... 27 2.3.3 ACOS ................................................................................................................. 27