SystemPeriod(level) returns the member from the specified level of the Time dimension. The returned member (date/time span) contains the current date and time at the time of execution.
Example:
SystemPeriod([Fiscal].[Quarter])
returns the member from the quarter level of the Time (Fiscal) dimension containing the current date and time (the current quarter).