There is only one keyword argument
- months:
The value to specify may be negative or positive; Use a positive value to get a date in the future, and a negative value to get a date in the past.
Notice:
This function maintains the last day of month when a day is 31. See the below second scenario outline for more details.
| Scenario Outline: The start date do not involve last day of month (6 examples) |
|
||
| Scenario Outline: The start date with 31 as last day (6 examples) |
|
Given the date {start date}
When relative delta {relative delta} is applied
Then the relative date should be {relative date}
Examples:
Given the date {start date}
When relative delta {relative delta} is applied
Then the relative date should be {relative date}
Examples:
| Number of Scenarios | 2 | Total Duration | 314ms |
| Total Number of Test Cases | 12 | Fastest Test | 18ms |
| Number of Manual Test Cases | 0 | Slowest Test | 33ms |
| Tests Started | Apr 11, 2023 10:42:07 | Average Execution Time | 21ms |
| Tests Finished | Apr 11, 2023 10:42:07 | Total Execution Time | 312ms |
| feature | Scenario | Context | Steps | Started | Total Duration | Result |
|---|---|---|---|---|---|---|
| EDATE Function |
1: The start date do not involve last day of month
description=next month, start date=2021-09-20, relative delta=months=+1, relative date=2021-10-20 |
3 | 10:42:07 | 033ms | ||
| EDATE Function |
2: The start date do not involve last day of month
description=last month, start date=2021-09-20, relative delta=months=-1, relative date=2021-08-20 |
3 | 10:42:07 | 029ms | ||
| EDATE Function |
3: The start date do not involve last day of month
description=next two months, start date=2021-09-20, relative delta=months=+2, relative date=2021-11-20 |
3 | 10:42:07 | 028ms | ||
| EDATE Function |
4: The start date do not involve last day of month
description=next three months, start date=2021-09-20, relative delta=months=+3, relative date=2021-12-20 |
3 | 10:42:07 | 019ms | ||
| EDATE Function |
5: The start date do not involve last day of month
description=next four months, start date=2021-09-20, relative delta=months=+4, relative date=2022-01-20 |
3 | 10:42:07 | 020ms | ||
| EDATE Function |
6: The start date do not involve last day of month
description=next five months, start date=2021-09-20, relative delta=months=+5, relative date=2022-02-20 |
3 | 10:42:07 | 018ms | ||
| EDATE Function |
1: The start date with 31 as last day
description=next month, start date=2021-10-31, relative delta=months=+1, relative date=2021-11-30 |
3 | 10:42:07 | 021ms | ||
| EDATE Function |
2: The start date with 31 as last day
description=last month, start date=2021-10-31, relative delta=months=-1, relative date=2021-09-30 |
3 | 10:42:07 | 019ms | ||
| EDATE Function |
3: The start date with 31 as last day
description=next two months, start date=2021-10-31, relative delta=months=+2, relative date=2021-12-31 |
3 | 10:42:07 | 019ms | ||
| EDATE Function |
4: The start date with 31 as last day
description=next three months, start date=2021-10-31, relative delta=months=+3, relative date=2022-01-31 |
3 | 10:42:07 | 019ms | ||
| EDATE Function |
5: The start date with 31 as last day
description=next four months, start date=2021-10-31, relative delta=months=+4, relative date=2022-02-28 |
3 | 10:42:07 | 018ms | ||
| EDATE Function |
6: The start date with 31 as last day
description=next five months, start date=2021-10-31, relative delta=months=+5, relative date=2022-03-31 |
3 | 10:42:07 | 018ms |