Choose Right Date Function. On the Rows shelf right-click YEARQuarter Date again and select Discrete. Formulas are a really helpful tool like in Excel or other well known analysis tools to better understand the dataset in front of you.
Max function to find latest date. 2013-04-12T1552010000 DATE_COOKIE - HTTP Cookies example. Select and right click on date cells that you want to customize and go to Format Cells.
On the Rows shelf right-click YEARQuarter Date again and select Discrete.
Choose More Controls from ActiveX Controls. Please read our DATE function VBA page if you are looking for the VBA version of the DATE function as it has a very different syntax. One is more needed than the other. The RIGHT function extracts a given number of characters from the right side of a supplied text string.