Date Dimension

[Anonymous]

I have a Date Dimension that pulls dates within last 60 days:

if(floor([completed_date.autoCalendar.Date])>=(today())-60, completed_date )

Only problem I have is that when this dimension is used in a graph, there is no ability to zoom-in unlike other date dimensions that I have used previously.

"Date([completed_date])"  leads to same error but not limited to 60 days, while just "completed_date" allows me to zoom in.  Any help to solve this small issue is appreciated.

[nsetty]

try

if(floor([completed_date.autoCalendar.Date])>=DATE((today())-60), completed_date )

[Anonymous]

Expression works, but same error as previous, no ability to zoom in to graph to narrow view.  Thanks though