Dates in a taglike column

[ownedbycats]

I have a column that stores dates.

Is any possible way to have it display as "January 1 2000, December 31 2010" but still sort in order of date?

[theducks]

Originally Posted by ownedbycats

I have a column that stores dates.

Is any possible way to have it display as "January 1 2000, December 31 2010" but still sort in order of date?

There is a tweak for real date types (not a text that looks like a date)

ID: gui_pubdate_display_format

[BetterRed]

Originally Posted by ownedbycats

I have a column that stores dates.

Is any possible way to have it display as "January 1 2000, December 31 2010" but still sort in order of date?

The Format of a Date column does not determine how it is sorted - to get what you want enter "MMMM d yyyy" into the Format field:



But that wont put the column into the Tag browser.

BR

[ownedbycats]

I'm putting the dates into a custom taglike column, so those won't help.

[theducks]

Originally Posted by ownedbycats

I'm putting the dates into a custom taglike column, so those won't help.

This is why we used ISO date format for early DB text fields:
20011204 (YYYYMMDD) They ASCII sort
Why not use a saved search? Or is your desire down to a day?
eg (mine is a date column, But any search should work AND the search name IS sorted in the list

#finished:2026

And the saved searches are included at the bottom of the Tag Browser

[ownedbycats]

Originally Posted by theducks

Why not use a saved search? Or is your desire down to a day?

I'm storing multiple dates.



The text-dates are nicer to read, but don't sort right

[BetterRed]

What happens of you store the data as a Date, and cloak it with a tag-like composite column viz:



BR

[ownedbycats]

using

program:

	new_dates = '';

	for dates in '#datesread':
		converted = format_date(dates, 'MMMM d yyyy');
		new_dates = list_union(new_dates, converted, ',')
	rof

seems to work, though the dates are backwards for some reason

EDIT: I fixed it by swapping the order of the list_union. I'm not sure i understand what happened but it works!