Forum Discussion

Ejykso's avatar
Ejykso
Icon for Helper I rankHelper I
3 years ago

Custom Date Period

Hi All,   I have a problem with my custom date period.  I'm using this: var _today = today() Return  union (  addcolumns ( calendar(date(year(_today), month (_today), 1), _today) ,"type", "m...
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

Why do you need to union these tables as it looks like they overlap?  In any case, here is a way to get a date range from the start of the current quarter.

 

 CALENDAR ( DATE ( YEAR ( _today ), FLOOR(MONTH ( _today ),3)+1, 1 ), _today )
 
Pat