Hi, I have now finished and managed to add the dates and properties at the same time to my calendar table.
So the table looks at this moment:
2012-12-01 property 1
2012-12-02 property 1
etc. until end of year
2012-12-01 property 2
2012-12-02 property 2
etc. until end of year (more properties to be added)
The next step is to update the table and add prices and description to make it easier to check the prices once done.
So now I wonder if for exampel I have rows with dates 1 january until 30 March description low then I have 1 April until 30 June description mid.
I know I can choose select low where property = property 1 however that will give me all rows from 1 january until 30 march.
I wonder if it is posible to select the first and last date for description low, so the result would be
property 1 low 2012-01-01
property 1 low 2012-03-30
That way I can check that the low season really ends when I want.
Thanks in advance