Would be nice to have the option to show just time from the datetime of entities in the month display of a calendar view.

Related: Although the below post is specifically about Grid view, it actually applies to all views: [image] Customize which entity fields (units) are displayed in Grid View relation columns it would be super useful to be able to customize which fields are displayed for each entity (instead of on…

You can extract the time from the datetime field using a formula. Obviously not as good as an editable field, but if you just need to show the time as a field on a card, maybe it’s good enough.

I’m having trouble seeing how I would do that with the function options provided - code you provide a pseudocode example?

FYI this topic’s title mentions filtering, but in the body text you just talk about showing the time, so I hope I understood the need correctly.

Awesome. I added .Start and .End values and a “-” to recreate the look of a time range. I’m running into the UTC issue others have mentioned elsewhere though, but let me elaborate. The “Date” being converted in the ToText() function is the date range field from a google calendar integrated event. W…

You could add/subtract an offset prior to convert to text, but there would still be issues with summer/winter time. Timezones are tricky

Okay maybe I can create some sort of conditional for the offset that adjusts by one offset value for half the year and another offset for the other half if I can figure out how to access second Sunday of March and first Sunday of November in the formula.

Also re: filtering I meant filter just the time from the date range value, but I think we’ve gotten the best solution given the existing Fibery capabilities.

[image] tycecycle: maybe I can create some sort of conditional for the offset that adjusts by one offset value for half the year and another offset for the other half if I can figure out how to access second Sunday of March and first Sunday of November in the formula. It is almost certainly p…

[image] tycecycle: Okay maybe I can create some sort of conditional for the offset that adjusts by one offset value for half the year and another offset for the other half if I can figure out how to access second Sunday of March and first Sunday of November in the formula. I could imagine it …

Option to filter on "time" from entity's datetime in month view

Ideas & Features

Matt_Blais October 2, 2023, 2:29pm 2

Related: Although the below post is specifically about Grid view, it actually applies to all views:

Topic		Replies	Views
Formatting UTC Date Get Help formulas , dates	13	562	December 5, 2023
Allow specifying TimeZone with ToText([Date]) Ideas & Features dates	13	644	April 29, 2026
toText(Date) wrong timezone? Bugs & Issues	12	1191	March 13, 2025
Timezone offset calculation API & Programming	9	5305	April 3, 2024
Twitter post about potentially new Fibery settings Misc	9	465	January 23, 2024

Option to filter on "time" from entity's datetime in month view

Related topics