43
edits
Changes
no edit summary
{{MYSQLDATETIMEFORMATS}}
===Calculate Business Day===
To calculate number of business day had passed, you need to do the following:
1. Create a holiday calendar and add all the holiday within that calendar.
2. Use the following syntax within Calculated Field when you build your report<br>
'''Syntax'''
SS_FUNC.countbusdays(date1,date2)
'''Example'''
SS_FUNC.countbusdays(now(),[this])- 1
==Conditional Statements==