https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-get-latest-date-using-mdx/m-p/38132#M4649 Hi,<BR /> <BR /> MDX is almost like an SQL syntax.<BR /> You could try to get the max of the date.<BR /> <BR /> sample: <BR /> <BR /> select max(date)as date from source;<BR /> quit;<BR /> <BR /> or<BR /> <BR /> select distinct(max (date_column)) from table_name Mon, 11 Jan 2010 02:11:57 GMT sasrac 2010-01-11T02:11:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-get-latest-date-using-mdx/m-p/38131#M4648 Hi,<BR /> <BR /> I have a measure that calculates the difference between two dates. <BR /> How will I get the latest date without inputting the date value so that it will automatically update the measure? I am using mdx in EG since my source is OLAP cube. <BR /> <BR /> Thanks! Fri, 08 Jan 2010 02:06:38 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-get-latest-date-using-mdx/m-p/38131#M4648 louise 2010-01-08T02:06:38Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-get-latest-date-using-mdx/m-p/38132#M4649 Hi,<BR /> <BR /> MDX is almost like an SQL syntax.<BR /> You could try to get the max of the date.<BR /> <BR /> sample: <BR /> <BR /> select max(date)as date from source;<BR /> quit;<BR /> <BR /> or<BR /> <BR /> select distinct(max (date_column)) from table_name Mon, 11 Jan 2010 02:11:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-get-latest-date-using-mdx/m-p/38132#M4649 sasrac 2010-01-11T02:11:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-get-latest-date-using-mdx/m-p/38133#M4650 you could also try this doc.<BR /> <BR /> sww.sas.com/base/olap/MDX%20Tutorial.doc Mon, 11 Jan 2010 02:21:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-get-latest-date-using-mdx/m-p/38133#M4650 sasrac 2010-01-11T02:21:19Z