I created a bunch of entries with start and finish times such as 10:00 / 14:00 a couple of months ago. Now that we’re out of BST and into GMT they’re all noted as 11:00 / 15:00 - i.e. they appear to be absolute time values displayed in the browser’s ...
On the latter: it appears that the DATETIME_FORMAT output strings were generated when we were in BST and then cached, and so didn’t change when we shifted out of BST. Modify the Date values (to their current values!) and the formatted values change. ...
(What I’m using this for is a view filter in Calendar mode: show items where linked columns are checked. If it were a checkbox list, then I can see the argument for having a view filter for all boxes checked, and for any boxes checked - and the inver...
Just to jump in here - I see that an attempt to group checkboxes via a Lookup column (against multiple records) results in a single checkbox, whose value appears to be “checked” if any of the linked columns’ checkboxes are checked, and clear otherwis...
For time-only fields I tend to use a datetime of 1970-01-01 HH:MM, and create a second formula field with DATETIME_FORMAT(_From, 'HH:mm') for display, hiding the original except when editing. So yes, a dedicated time-only data type would be good.
