I have file filed with thousands of names and it would be nice to have the option to have section headers under the alpha sort for two letters. I realize that the number of headers could be up to 650, so it might be necessary to limit the second letter to vowels (156 headers a,e,i,o,u,y), and suppress combinations that don’t appear in the data.
I would also like to have a date format, MMM YYYY, e.g., Nov 2017.
Hi,
You could create a Calculation field with the string function LEFT(Column_Name;2) where Column_Name would be the name of the column with names.
Then Grouping Records by this column will solve your problem.
For customizing Dates you can also use the function DATE(X;”YYYY-MMM-dd”) where X can be a date column and the following string the format you want.
Hope this helps,
Jose
Great ideas Jose!
Also you can set the Date Format on a Date field directly to a variety of formats.
.
