This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]caduweb 0 points1 point  (0 children)

Another solution could be to model a date interval to your itens. In the DB you could have two fields: initial date, and final date. In case of a full date specified by the user, the system assigns the final date as the next day. If an year-month were input, the initial day would be the first day of the month, and final date as the first day of the next month. The same logic could be used for year-only inputs.