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