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. |