Hello friends, this issue suddenly occurred, as it has been working fine until now, and I haven’t been able to determine the root cause. I have a table in a spreadsheet with many date columns, and in another table, I use transpose to combine these dates to be used as a list that I will use as options for the choice component.
Here, I only found a strange symptom when filling in the “Date Choice” using the choice component, the if-else matching does not work, but with manual input, the if-else column works as expected. With the description above, I hope it can be understood because it is very complex I did not elaborate on everything.
My guess would be that your Dates also contain a time component, and as you’re trying to do exact comparisons with the if-then-else, you get inconsistent results.
In a case like this, I would convert all dates to integers in YYYYMMDD format using a math column, then use that in any subsequent matching logic.
I suspected as much. Can I do this formatting in the spreadsheet itself, as the number of columns will increase significantly if I add a math column (sorry for bargaining)? I’m still a bit curious because the source application I duplicated is still working fine, so I think it’s still possible to match the format.
Yes, there is a difference. If I turn on Date&Time, it will display: Friday, 1 March 2024 at 12:00 and Friday, 1 March 2024 at 0:00. Does turning on only “Date” without “Time” still include the time in the matching?
I have found the issue and it is now working normally. The problem was when using the date-time picker component. I have now changed this component to just the date picker component. Thank you, Darren.
Just so you know, when you use the date picker or date-time picker, both a date and time will be saved in the value of the timestamp. The difference is that the date-time picker allows the user to be more granular with the time element, while the date picker will default to 00:00:00 (12 AM) on the chosen date.
Yes Nathanael, the error is that if you use the Date&Time pickers, glide will make the default time 12.00am.
In Gsheet, if I reference to another cell then the hour changes to 00.00. As a result, when conditioned it cannot be found.
However, if I use Date Picker (without time), the data received in G Sheet is 00.00.
Since in this context I only need the date, I just change it to “Date Picker”.
Thank you for your attention.
