Some date ranges don’t show up in publish index table?

[patrickyan]

The dates are present in the entry, but don’t show up in the table. The data source output is fine, too.

[nilshoerrmann]

Could you be more specific. What does happen and what do you expect to happen?

[patrickyan]

Take a look at the screenshots: The date range saved is as shown (2013-10-01 to 2013-10-22). It should show that in the entries table. Some entries show the range, and some only show the first date. The range itself is saved correctly and outputted correctly.

[nilshoerrmann]

Could you please be a bit more specific: all entries contain the range shown in the second image? Or only one of them? Is it always this single range or are there entries with multiple dates?

[patrickyan]

1. No, they vary. For example, another one is 2013-10-03 to 2013-10-24, but only 2013-10-03 shows up. Same with another one that has 2013-10-01 to 2013-10-05. However, another entry with 2013-10-09 to 2013-10-31 shows the entire range.

   It seems like it could be related to the first date that is before today? Right now it’s 2013-10-04, and all the ones that start with 2013-10-01, 2013-10-3, etc. do not show the correct range.

2. Single range only.

[patrickyan]

But then again, I have another entry that is 2013-10-01 to 2013-11-30, and it shows the range correctly.

[nilshoerrmann]

So this is not about whole ranges missing but about ranges that only display the start date, right?

[patrickyan]

Correct. The edit view and data sources have the correct ranges. Only the entries table shows incorrect/incomplete data.

[nilshoerrmann]

To debug this I'd need the following data from you for the affected entries:

1. the values you see in the UI when editing an entry
2. the values you see in the UI when viewing the section index
3. the values actually stored in your database

Thanks!

[patrickyan]

Values in edit view

1. 2013-10-03 → 2013-10-24
2. 2013-10-01 → 2013-10-22
3. 2013-10-01 → 2013-10-15

Values in section index

1. 2013-10-03
2. 2013-10-01
3. 2013-10-01

Values in database

1. start: 2013-10-03 15:33:37, end: 2013-10-24 15:33:37
2. start: 2013-10-01 14:59:19, end: 2013-10-22 14:59:19
3. start: 2013-10-01 15:43:15, end: 2013-10-15 15:43:15

[nilshoerrmann]

Thanks. One last thing: which Symphony and Date and Time versions are you using?

[patrickyan]

I’m using:

Symphony 2.3.3
Date and Time 3.1.2

[nilshoerrmann]

Seems to be fixed by 1f18eec – thanks, Nicolas!

[nitriques]

Great! My pleasure!