Use this expression to get the current date.
Syntax
Get Current date as a string () = local/output variable
Sample
1. Get Current date as a string () = 2018-12-28 15:37:59.200000
Use this expression to get date / month / year value of the date parameter provided in dd/mm/yyyy
Syntax
Get (what_to_get, date_string) = output
Sample
1. Get (month, 21/12/1987) = 12
Parameter Details
Input Parameter Name |
Description |
what_to_get |
Date / Month / Year. |
date_string |
Date value for which the output is expected. |
Use this expression to get the current date in the format mentioned in the parameter.
Syntax
Current Date and time string (format) = output
Sample
1. Current Date and time string (%d/%m/%Y) = 28/12/2018
2. Current Date and time string (%y-%m-%y) = 18-12-28
3. Current Date and time string (%Y.%d.%m) = 2018.28.12
Parameter Details
Input Parameter Name |
Description |
format |
Required date formats. |
Use this expression to convert the date given in string data type to the date data type.
Syntax
Convert string to date format (format) = output
Sample
1. Convert string to date format (‘13-10-2014’,'%d-%m-%Y) = 13-10-2014 (as date data type)
2. Current Date and time string (('2013/10/05', '%Y-%d-%m') = 2013-10-05
Parameter Details
Input Parameter Name |
Description |
date_string1 |
Date in string data type. |
string_format |
Format in which it has be converted. |
Use this expression to set a specific date / month / year for the current date.
Syntax
Set Period (what, value) = output
Sample
1. Set Period (Year,1988) = 28-12-1988
2. Set Period (month,6) = 28-6-2018
3. Set Period (date,1) = 01-12-2018
Parameter Details
Input Parameter Name |
Description |
what |
What part of the date to be changed (Year / Month / Date). |
value |
Desired value as required to change the date. |
Use this expression to get the start date / end date of the month.
Syntax
Start Or End Of The Month (start_or_end) = output
Sample
1. Start Or End Of The Month (start) = 01st Dec 2018
2. Start Or End Of The Month (end) = 31st Dec 2018
Parameter Details
Input Parameter Name |
Description |
start_or_end |
Gives the Start / End date of the current month based on the parameter provided. |
Use this expression to get the start date / end date of the week.
Syntax
Start Or End Of The Week (start_or_end) = output
Sample
1. Start Or End Of The Week (start) = 24th Dec 2018
2. Start Or End Of The Week (end) = 31st Dec 2018
Parameter Details
Input Parameter Name |
Description |
start_or_end |
Gives the Start / End date of the current week based on the parameter provided |
|
Monday is considered the start and Sunday to be end of the week. |
Use this expression to add the number of days for the given date.
Syntax
Add Days (howmany, to_date, format_1) = output
Sample
1. Add Days (12,12/12/1988, %d/%m/%Y) = 24/12/1988
2. Add Days (12,88/12/12, %y/%m/%d) = 1988/12/24
Parameter Details
Input Parameter Name |
Description |
howmany |
Number of days to be added. |
|
Monday is considered the start and Sunday to be end of the week |
To_date |
Date for which the days must be added |
Format_1 |
Date Format of the ‘To_date’ parameter |
Use this expression to subtract the number of days from the given date.
Syntax
Subtract Days (from_date, howmany, format_1) = output
Sample
1. Subtract Days (12/12/1988, 11 , %d/%m/%Y) = 01/12/1988
2. Subtract Days (1988/12/12, 11, %Y/%m/%d) = 1988/12/01
Parameter Details
Input Parameter Name |
Description |
from_date |
Date for which the days must be subtracted. |
|
Monday is considered the start and Sunday to be end of the week. |
howmany |
Number of days to be subtracted. |
Format_1 |
Format of the ‘ from_date’ parameter. |
Use this expression to add the number of months for the given date.
Syntax
Add Months (howmany, to_date, format_1) = output
Sample
1. Add Months (12,12/12/1988, %d/%m/%Y) = 12/12/1989
2. Add Months (1,1988/06/12, %Y/%m/%d) = 1989/07/12
Parameter Details
Input Parameter Name |
Description |
howmany |
Number of months to be added. |
to_date |
Date for which the days must be added. |
Format_1 |
Date Format of the ‘to_date’ parameter |
Use this expression to subtract the number of months from the given date.
Syntax
Subtract Months (from_date, howmany, format_1) = output
Sample
1. Subtract Months (12/12/1988, 11 , %d/%m/%Y) = 12/01/1988
2. Subtract Months (1988/12/12, 11, %Y/%m/%d) = 1988/01/12
Parameter Details
Input Parameter Name |
Description |
from_date |
Date for which the months must be subtracted. |
howmany |
Number of months to be subtracted. |
Format_1 |
Format of the ‘ from_date’ parameter. |
Use this expression to add the number of years for the given date.
Syntax
Add Years (howmany, to_date, format_1) = output
Sample
1. Add Years (12, 12/12/1988, %d/%m/%Y) = 12/12/2000
2. Add Years (03, 1988/12/12, %Y/%m/%d) = 1991/12/12
Parameter Details
Input Parameter Name |
Description |
howmany |
Number of days to be added. |
|
Monday is considered the start and Sunday to be end of the week |
To_date |
Date for which the days must be added |
Format_1 |
Date Format of the ‘To_date’ parameter |
Use this expression to subtract the number of years from the given date.
Syntax
Subtract Days (from_date, howmany, format_1) = output
Sample
1. Subtract Days (12/12/1988, 11 , %d/%m/%Y) = 01/12/1988
2. Subtract Days (1988/12/12, 11, %Y/%m/%d) = 1988/12/01
Parameter Details
Input Parameter Name |
Description |
from_date |
Date for which the years must be subtracted. |
howmany |
Number of years to be subtracted. |
Format_1 |
Format of the ‘from_date’ parameter. |
Use this expression to get the start date / end date of the year.
Syntax
Start Or End Of The Year (start_or_end) = output
Sample
1. Start Or End Of The Year (start) = 01st Jan 2019
2. Start Or End Of The Year (end) = 31st Dec 2019
Parameter Details
Input Parameter Name |
Description |
start_or_end |
Gives the Start / End date of the current year based on the parameter provided |
The date changes to the start date of the current week/month/year.
Syntax
what (week/month/year) = output
Sample
what (week) = 30/12/2019
Parameter Details
Input Parameter Name |
Description |
What |
The value (week/month/year) to be changed to start date of the specified period |
The date changes to the end of the specified week/month/year.
Syntax
what = output
Sample
what (week) = 5/1/2020
Parameter Details
Input Parameter Name |
Description |
What |
Type the value (week/month/year) to be changed to end date of the specified period. |