Time Intelligence Functions

CLOSINGBALANCEMONTH (Expression, Dates, [Filter])
Evaluates the specified expression for the date corresponding to the end of the current month after applying specified filter.

CLOSINGBALANCEQUARTER (Expression, Dates, [Filter])
Evaluates the specified expression for the date corresponding to the end of the current quarter after applying specified filters.

CLOSINGBALANCEYEAR (Expression, Dates, [Filter], [YearEndDate])
Evaluates the specified expression for the date corresponding to the end of the current year after applying specified filters.

DATEADD (Dates, NumberOfIntervals, Interval)
Moves the given set of dates by a specified interval

DATESBETWEEN (Dates, StartDate, EndDate)
Returns the dates between two given dates.

DATESINPERIOD (Dates, StartDate, NumberOfIntervals, Interval)
Returns the dates from the given period.

DATESMTD (Dates)
Returns a set of dates in the month up to current date.

DATESQTD (Dates)
Returns a set of dates in the quarter up to current date.

DATESYTD (Dates, [YearEndDate])
Returns a set of dates in the year up to current date.

ENDOFMONTH (Dates)
Returns the end of month.


About the Author



Silan Software is one of the India's leading provider of offline & online training for Java, Python, AI (Machine Learning, Deep Learning), Data Science, Software Development & many more emerging Technologies.

We provide Academic Training || Industrial Training || Corporate Training || Internship || Java || Python || AI using Python || Data Science etc





 PreviousNext