Table of Contents
Data in Date type can be converted to Decimal, Integer or String type. You can also perform the following operations:
This operation adds an increment value to the day.
| Input | Increment | Output |
|---|---|---|
| 2009-12-27 | 5 | 2010-01-01 |
| 2009-12-14 | 5 | 2009-12-19 |
This operation adds an increment value to the month.
| Input | Increment | Output |
|---|---|---|
| 2009-05-14 | 2 | 2009-07-14 |
| 2009-12-14 | 2 | 2010-02-14 |
This operation adds an increment value to the year.
| Input | Increment | Output |
|---|---|---|
| 2009-12-14 | 1 | 2010-12-14 |
| 2011-12-01 | 1 | 2012-12-01 |
This operation shows only the day value from the selected field.
| Input | Output |
|---|---|
| 2009-12-14 | 14 |
| 2011-06-23 | 23 |
This operation changes the day value to the first day of each month.
| Input | Output |
|---|---|
| 2009-12-14 | 2009-12-01 |
| 2011-06-23 | 2011-06-01 |
This operation changes the day value to the last day of each month.
| Input | Output |
|---|---|
| 2011-02-03 | 2011-02-28 |
| 2008-02-03 | 2008-02-29 |
This operation changes each value in the selected field to a specified maximum value. If the original value is less than the specified maximum, the result becomes the maximum, otherwise it is unchanged.
| Input | Maximum | Output |
|---|---|---|
| 2011-04-05 | 2011-01-01 | 2011-04-05 |
| 2010-01-01 | 2011-01-01 | 2011-01-01 |
This operation changes each value in the selected field to a specified minimum value. If the original value is greater than the specified minimum, the result becomes the minimum, otherwise it is unchanged.
| Input | Minimum | Output |
|---|---|---|
| 2011-01-01 | 2011-04-05 | 2011-01-01 |
| 2011-05-01 | 2011-04-05 | 2011-04-05 |
This operation shows only the month value from the selected field.
| Input | Output |
|---|---|
| 2009-12-14 | 12 |
| 2011-06-23 | 6 |
This operation shows the month value from the selected field in a long name.
| Input | Output |
|---|---|
| 2009-12-14 | December |
| 2011-06-23 | June |
This operation shows the month value from the selected field in a short name.
| Input | Output |
|---|---|
| 2009-12-14 | Dec |
| 2011-06-23 | Jun |
This operation displays the Null dates as a specified value, while the other dates remain the same.
| Input | Value | Output |
|---|---|---|
| 2000-01-01 | 2000-01-01 | |
| 2008-06-23 | 2000-01-01 | 2008-06-23 |
This operation returns integers to show which quarter the specified dates belong to.
| Input | Output |
|---|---|
| 2010-10-16 | 4 |
| 2011-02-07 | 1 |
| 2011-04-19 | 2 |
| 2011-07-20 | 3 |
This operation returns strings to show which quarter the specified dates belong to.
| Input | Output |
|---|---|
| 2010-10-16 | Q4 |
| 2011-02-07 | Q1 |
| 2011-04-19 | Q2 |
| 2011-07-20 | Q3 |
This operation enables you to set the day value in the selected field.
| Input | Day | Output |
|---|---|---|
| 2011-01-01 | 20 | 2011-01-20 |
| 2009-07-17 | 20 | 2009-07-20 |
This operation enables you to set the month value in the selected field.
| Input | Month | Output |
|---|---|---|
| 2011-01-01 | 1 | 2011-01-01 |
| 2009-07-17 | 1 | 2009-01-17 |
This operation enables you to set the year value in the selected field.
| Input | Year | Output |
|---|---|---|
| 2011-01-01 | 2011 | 2011-01-01 |
| 2009-07-17 | 2011 | 2011-07-17 |
This operation subtracts a decrement value from the day.
| Input | Decrement | Output |
|---|---|---|
| 2009-12-27 | 5 | 2009-12-22 |
| 2009-12-05 | 5 | 2009-11-30 |
This operation subtracts a decrement value from the month.
| Input | Decrement | Output |
|---|---|---|
| 2009-12-14 | 1 | 2009-11-14 |
| 2009-01-22 | 1 | 2008-12-22 |
This operation subtracts a decrement value from the year.
| Input | Decrement | Output |
|---|---|---|
| 2009-12-27 | 2 | 2007-12-27 |
| 2011-02-05 | 2 | 2009-02-05 |
This operation transforms dates into a specified String format. Use "dd" for day, "MM" for month, and "yy" or "yyyy" for year. Specify a punctuation to connect the string.
| Input | String format | Output |
|---|---|---|
| 2009-12-27 | dd/MM/yyyy | 27/12/2009 |
| 2011-01-05 | dd/MM/yyyy | 05/01/2011 |
This operation changes the hour, minute and second values to zero. In most cases, the result looks the same with the original dates. However, manipulation has taken place to ensure that there are no hidden hours, minutes or seconds. Therefore, comparing and sorting will remain unaffected by those hidden values.
| Input | Output |
|---|---|
| 2009-12-27 | 2009-12-27 |
| 2010-12-05 | 2010-12-05 |