I've searched the forum and net but can't find anything tht exactly explains how I can fix my problem. The closest I've come is this thread
I'm using Datepicker to pass date parameters to an MDX query.
The Date Picker uses the format YYYY-MM-DDTHH:MI:SS e.g 2010-01-01T00:00:00
My Key is 20100101
I've tried various things but can't get it to transform the datepicker date correctly. Two examples below. Does anyone have any insight in to what else I could try.
STRTOMEMBER("[Date].[Date].&[" + Format(CDate(@StartDateParam), "yyyyMMdd") + "]") :
View Complete Post