E.g. I might want Feb 3 or 2/3 vs the current “short” option of 3/3/2021 which is cumbersome. Also, I’d rather not have to implement multiple helper columns in a sheet to generate something along the lines of the following where we show days if less than 30 days, months if less than 12 months, then…

Have you looked at this plugin? [image] new Format Date Plugin I’m making a new column each morning with my coffee. This morning I made Format Date : [image] You can read about the formatting options here: luxon - Immutable date wrapper Please give it a whirl! I am al…

Or this [image] new Relative Time ("1 hour ago") Plugin The Relative Time plugin transforms a date time value into a relative description like “2 hours ago.” [image] Please play with it and check out the documentation for the underlying library and give your feedback.…

Thanks, @Jeff_Hager ! I’m new to Glide. Love your prompt and helpful responses. Will dig into the plugins. Are they robust and reliable to use? I’d feel more comfortable if they were standard Glide features will test them anyway.

At the moment, they require the experimental column, so use it with a grain of salt. As for using the standard built in column types, you can usually get creative with the math, template, or if columns to parse out pieces of a date and manipulate it, but it would go against your preference of doing…

Thanks. Yes, I just watched a video on doing this using a math column and (Now - post.date) to create an integer for days ago and then using a template column to create text along the lines of “xx days ago”. And then create another column to handle the special case of “1 day ago” vs “1 days ago”. A …

Well, you can do some crazy things with some math. ;-). But I would experiment with the plugins if you are looking for a simpler solution. Maybe they will turn into native features some day, but for now it’s a quick and dirty way to plug in some extra features with little work.

Add more date formats and time-since calculations

Feature Requests

Jeff_Hager October 27, 2021, 3:45pm 3

Or this

Topic		Replies	Views
🆕 Format Date Plugin General	58	2818	August 22, 2022
'3 days ago', 'a month ago' 'tomorrow' Ask for Help	17	2669	September 27, 2023
Format Days Countdown Ask for Help	3	453	January 3, 2023
Display Date in different formats Ask for Help	5	2270	February 17, 2022
Date relative translation Ask for Help	17	886	December 7, 2021

Add more date formats and time-since calculations

Related topics