I need a database of my subscriptions and recurring expenses. Some of them recur monthly — and some recur yearly. I want to create a table to keep track of them. I want to create a column for monthly dates and another for yearly dates. Since these dates repeat each period, is there a date format to do this that would sort correctly? Or would they be best handled as a text field? I do notice there is a date format for month and day (Jan 10) without a year attached. Would this sort correctly or does it need an underlying non-displayed year?
Thanks.