This section provides information on the NOW member for date/time levels. This syntax is an InterSystems extension to MDX.
Basic Syntax
date_time_level.[NOW]
Where:

date_time_level is a level expression that refers to a level in a date/time dimension.
This syntax returns the member of the given level that corresponds to the current date and time. The following table shows examples (created on 24 May 2012):
Expression  Returned member 

You can also use expressions of the following form:
date_time_level.[NOWinteger]
Or:
date_time_level.[NOW+integer]
The following table shows examples (created on 24 May 2012):
Expression  Returned member 

Be careful when using such expressions with a time level that is independent of the overall calendar. In such cases, [NOWinteger ] refers to an earlier bucket in a cycle. Notice the third example in the table. The birthqd.quarter level groups records by quarter, independent of year. For this level, NOW refers only to the current quarter number. This level has four members in a cycle, and for this level, [NOW4] is equivalent to [NOW].
The same logic applies to expressions of the form [NOW+integer ].
You cannot use NOW in range expressions for a level that is based on any of the following time functions:
Time Function...  Typical Members  Notes 

Q4  These levels are independent of the year  
November  
24  This level is independent of the year and the part of the year  
1am  These levels are independent of the day  
01:24 
For a level that is based on the DayMonthYear time function, DeepSee supports the additional expressions that use a combination of year count, month count, and day count, as follows:
daymonthyear_level.[NOWoffset_expression]
Or:
daymonthyear_level.[NOW+offset_expression]

nn is a one or two digit integer.
The following table shows examples (created on 24 May 2012):
Expression  Returned member 

By default, the units are added together. For example, 4y3m2d means four years plus three months plus two days.
You can instead include a minus sign between units to subtract. 1y1d means one year, minus one day. For example:
Expression  Returned member 

DeepSee automatically accounts for leap years. The internal logic also accounts for the varying lengths of the months.