Date

Get Current date as a string

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

Get

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.

Current Date and time string

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

Convert string to date format

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

Set Period

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.

Start Or End Of The Month

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.

Start Or End Of The Week

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.

Add Days

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

Subtract Days

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.

Add Months

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

Subtract Months

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.

Add Years

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

Subtract Years

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.

Start Or End Of The Year

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

Change to Start of Period

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

Change to End of Period

The date changes to the end of the specified week/month/year.

Syntax 

what() = output

Sample 

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