I am attempting to make a database for my social media. I am having trouble with the best way to organize it. I struggle with how I can put things in DATE order, We typically do Month and Week # so we don't have to change the date each year, but then it doesn't go in month order.
I would like one grid with all our marketing ads, then some sort of way to separate for each type by date (either as a gallery or grid). My questions are- What is the best way to sort by date? If I have 1 row listing multiple dates, can I have another grid or form listing each week/date individually?
For the image listed, I would like some sort of sorting to separate by date:
Example:
First week of the month Special
June Special