0

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.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • zenmom
    • zenmom
    • 2 mths ago
    • Reported - view

    Wait wait wait...  forgot that I already posted this. I'll post again if I get lost in the weeds.

    Like
    • zenmom The solution to this sort of problem is to use the month as numbers, but formatted in reverse order:  format('date paid [raw]',"YYYY MM DD")

      Like
Like Follow
  • 2 mths agoLast active
  • 2Replies
  • 23Views
  • 2 Following