Date Formulae
Introduction
Sapper supports a variety of Date formulas. Those are mentioned in this section.
- 1 Introduction
- 2 Formulas
- 2.1 Current Date
- 2.2 Modify Date
- 2.3 Previous Date
- 2.4 Day of week
- 2.5 Day number of year
- 2.6 Start of Hour
- 2.7 Start of Day
- 2.8 Start of Month
- 2.9 Start of Year
- 2.10 Start of Week
- 2.11 Last day of Month
- 2.12 To covert Specific Format
Formulas
Current Date
Description | It represents the current date with output and time zone. |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Modify Date
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Previous Date
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Day of week
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Day number of year
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Start of Hour
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Start of Day
Description | It represent the returns date and time for midnight on date of a given date or date and time. |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Start of Month
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Start of Year
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Start of Week
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
Last day of Month
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |
To covert Specific Format
Description | It represent the |
Syntax | Expression: Return Type: |
Example | Expression: Result: |