Date and Time Functions

Function Name :

DateValueEx.SK

Function Description :

Returns numerical date value of the given date text according to the provided format text. Custom format can be used to calculate value of date in text also if the input data consists multiple formats you can add range of formats to match in order t convert the date text into value

Function Arguments :

  • Date_Text: the input Date which you want to convert in the date.

  • Format_Text: The format in which you want the date.

Function Name :

EOPERIOD.SK

Function Description :

Returns the last date of the period after adding the number of periods in the second argument

Function Arguments :

Start Date: Date which is needed as reference date.
periods: It denotes the number of periods ahead of Start Date
period_length: It denotes the length of period in number of months
start_month: It denotes the starting month of any one period. It takes 1 as value by default .

Function Name :

NOW.SK

Function Description :

Returns time of the last run

Function Arguments :
Input should be kept blank.