I need to add one record for every month.
For example, the user will choose from drop down list like:
(sorted according to month)
How can I achieve this? and what's the best field type to store it?
Use a date field where a value such as 12/1/2016 but formatted to display as shown in your original post. Don't use a value list for selecting the date. Use a selection portal inside a popover to get the values sorted and formatted the way that you want. (A deployable button bar could also be used.)
Sorting by month is hard when they begin with the month name. Instead sort by year month:
What's the best data type to store those months?
Should I store them as text or date?
If I store the data as text then won't it be hard to create reports etc.. Like summary for every year, or summary for every quarter etc..?
Thank you philmodjunk.
Retrieving data ...