Expand cannot
Shorten also cannot
yes of course thank you
So your Start and End Dates compare to Dates in a Bookings table - is that right?
The reason I am asking about Dates is that I saw something similar in one of my own Apps just 2 days ago, and when I dug into it I found that I was using the Format Date column. As soon as I got rid of that, my problem was solved…
Yes, you are right.
but i really dont understand . did you guys did any updates and changes of the date format ? because all this while are okay,
i have to check back all the dates column , very troublesome for me.
I didn’t do anything. I’m just a poor user like you 
But I do know from experience that some of the date related plugin columns are unreliable. Sometimes they work, and sometimes they don’t 
2 days ago? i think its because the update. glide notify there is an update. and after i did the update suddenly my user said it is not working .
So , what you did is change the Format Date column to text column?
Show me how you are using Format Date, and I will try to give you an alternative.
oh but i found weird things.
this table called Add New
and another table Fleet,
it is referring to the Add New table
but different date showing. suppose to be 17 of May?
Yes, that is odd.
There is definitely only one column called Start Date in the Add New table?
If you delete the values and enter a new date, does it pick up the correct value?
(by the way, it looks like you’re not even using the Format Date column?)
I often see you use this word “meh”. What does it mean?
No no, that’s just a display option.
What I was referring to is this. But you’re not using it, so don’t worry about it.
Anyway, hmmm… I’m not really sure what the problem is here.
@Jeff_Hager might have a clue…
hhaha @Darren_Murphy please explain to him what “meh” means
Okay-lah…
2 Likes
yes, its formula for date overlapping .
Very Malay -lah 
1 Like
Try displaying the time in your column. Is it the same between the Glide table and G. sheet. Is it 0.00 or 12.00
This is what I experienced. Does the choice happen a day apart for you?
This happens since Glide’s date time format uses 12.00 AM, whereas in G. Sheets the change of day is considered 0.00 AM