This idea is not mine. I have voted for it and added a comment.
BFP-I-389: Extend support for casting common strings into date objects
The
date
inspector should accept common formats as string input. While it’s great that the following is possible, converting an ISO-8601 date into a useful object should not require these histrionics:
q: date (( (tuple string item 2 of it) & " " & ((month it as string) of (tuple string item 1 of it as integer)) & " " & (tuple string item 0 of it) ) of (tuple strings of (substrings separated by "-" of it) of (preceding text of last "." of following text of first "_" of "foo_2025-05-20.bar")))
A: Tue, 20 May 2025
T: 0.126 ms
I: singular date