Date formats
Okay! I've got a new question! I prefer to see dates in something approximating the European style, that it, [day] [month] [year]. Since I live in the U.S., I've been writing my dates as "12 May 2022", with the month part being letters instead of numbers, b/c otherwise "2/11/22" could be taken as either February 11th, 2022, or November 2nd, 2022. I looked for a way to display dates in that format, and came up with this:
format('date paid [raw]',"DD MMM YYYY")
where 'date paid [raw]' is the name of a field where I've entered the date through the calendar that pops up when you click on a date field.
And the result looks great! But... when I go to sort, it doesn't recognize it as a date field (b/c it's a formula field, of course), and the sort comes out as if it were a text field.
My question... is there a way to have the date displayed as I perfer, and have it actually be recognized as a date field? I'm kind of a beginner here, so I may have overlooked an option.
TIA for any thoughts on this.
2 replies
-
Wait wait wait... forgot that I already posted this. I'll post again if I get lost in the weeds.
Content aside
- 1 yr agoLast active
- 2Replies
- 69Views
-
2
Following