Changes

Jump to: navigation, search

Calculated Field

369 bytes added, 16:22, 29 January 2014
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==
43
edits

Navigation menu